SQL ORDER BY DESC
此语句用于按降序对数据进行排序。您应该按如下所示在ORDER BY子句中使用DESC属性。
SELECT supplier_city
FROM suppliers
WHERE supplier_name = 'IBM'
ORDER BY supplier_city DESC;
让我们看一个雇员表的示例:
| 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 |
这是一个按名称对结果进行降序排序的示例。
SELECT * FROM CUSTOMERS
ORDER BY NAME DESC;
这将产生以下结果。
| 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 |
