Loading

display order by

JAYRAM

12y1.2k

I have table like

sno name id
1 ras 1
2 nnn 3
3 raju 2
4
.
.
.
.

2000 vamshi 2000

i want to select order by id

but iam using this quarie
selec * from tablename orderby id asc
using above quarie not display order

plz write quarie......

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Trivedi12y ago
hi,

you query must work because it is correct query. can you please share output the query ?
0
Abhay Shanker12y ago
Add a space between order and by as below

SELECT * FROM [TableName]
ORDER BY id ASC/DESC
0
saurabh mittal12y ago
Hi
       Query For select record in Order By-

        Select * from Table_name Order By id ASC/DESC
0
Munesh Sharma12y ago
use this query

select * from tablename order by id asc
0