Question

2. Write the steps to sort a data set on the basis of a column named CITY in ascending order
and then on the basis of a column name POPULATION in descending order.
​

Answer 1

Answer:

Order by clause is used with SELECT statement for arranging retrieved data in sorted order. The Order by clause by default sorts the retrieved data in ascending order. To sort the data in descending order DESC keyword is used with Order by clause.