display order by

Question

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......

Jignesh Trivedi · Answer

hi you query must work because it is correct query. can you please share output the query ?

Abhay Shanker · Answer

Add a space between order and by as below SELECT * FROM [TableName] ORDER BY id ASC/DESC

saurabh mittal · Answer

Hi Query For select record in Order By- Select * from Table_name Order By id ASC/DESC

Munesh Sharma · Answer

use this query select * from tablename order by id asc