0

Display record of each table in ascending order

2nd Dec 2016, 8:43 AM
nikhil
nikhil - avatar
3 Respuestas
+ 2
by default result of "order by" clause is in ascending order no need to write asc for descending order you have to mention "desc" select dept_no, dept_name from dept order by dept_no desc; result- dept_no. dept_name 50. sales 30 marketing 20 hr
2nd Dec 2016, 5:13 PM
Samrat Indra
Samrat Indra - avatar
+ 1
Try with SELECT * FROM table_name ORDER BY table_id ASC;
2nd Dec 2016, 1:18 PM
Aleksandar
Aleksandar - avatar
+ 1
thanks
2nd Dec 2016, 9:00 PM
nikhil
nikhil - avatar