Display record of each table in ascending order

Answer 1

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

Answer 2

Try with SELECT * FROM table_name ORDER BY table_id ASC;

Answer 3

thanks