Question

Explain the term sorting in ascending order and descending order using suitable examples?
answer it.​

Answer 1

Answer:

in SQL

Order by <column name>

is used for sorting in ascending and descending order.

for eg , you need to order the query in descending order of date (date is a column name in a table/relation)

we write,

select * from student

order by date Desc;

Answer 2

Answer:

in SQL

Order by <column name>

is used for sorting in ascending and descending order.

for eg , you need to order the query in descending order of date (date is a column name in a table/relation)

we write,

select * from student

order by date Desc;