All for Joomla All for Webmasters

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.

  1. SELECT supplier_city
  2. FROM suppliers
  3. WHERE supplier_name = ‘IBM’
  4. ORDER BY supplier_city DESC;

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.

  1. SELECT * FROM CUSTOMERS
  2. ORDER BY NAME DESC;

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
PinIt
submit to reddit

Leave a Reply

Top