SQL ORDER BY CLAUSE WITH DESCENDING ORDER: This statement is used to sort data in descending order. You should use the DESC attribute in your ORDER BY clause as follows.
Let's see an example of an employee table:
ID |
NAME |
AGE |
ADDRESS |
SALARY |
1 |
Himani gupta |
21 |
Modinagar |
22000 |
2 |
Shiva tiwari |
22 |
Bhopal |
21000 |
3 |
Ajeet bhargav |
45 |
Meerut |
65000 |
4 |
Ritesh yadav |
36 |
Azamgarh |
26000 |
5 |
Balwant singh |
45 |
Varanasi |
36000 |
6 |
Mahesh sharma |
26 |
Mathura |
22000 |
This is an example to sort the result in descending order by NAME.
This would produce the following result.
ID |
NAME |
AGE |
ADDRESS |
SALARY |
2 |
Shiva tiwari |
22 |
Bhopal |
21000 |
4 |
Ritesh yadav |
36 |
Azamgarh |
26000 |
6 |
Mahesh sharma |
26 |
Mathura |
22000 |
1 |
Himani gupta |
21 |
Modinagar |
22000 |
5 |
Balwant singh |
45 |
Varanasi |
36000 |
3 |
Ajeet bhargav |
45 |
Meerut |
65000 |
|