0
Display record of each table in ascending order
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
+ 1
Try with SELECT * FROM table_name ORDER BY table_id ASC;
+ 1
thanks