「SQL」order byで指定項目の降順(desc)で並ぶサンプル
構文
SELECT カラム1, カラム2, xxx
FROM テーブル名
ORDER BY カラム1, カラム2, xxx DESC
使用例
SELECT ContactName,Address,City,Country FROM
Customers
ORDER BY ContactName DESC,Country DESC
SELECT ContactName,Address,City,Country FROM
Customers
ORDER BY ContactName DESC,Country DESC
SELECT ContactName,Address,City,Country FROM Customers ORDER BY ContactName DESC,Country DESC
実行結果
| ContactName | Address | City | Country |
|---|---|---|---|
| Zbyszek | ul. Filtrowa 68 | Walla | Poland |
| Yvonne Moncada | Ing. Gustavo Moncada 8585 Piso 20-A | Buenos Aires | Argentina |
| Yoshi Tannamuri | 1900 Oak St. | Vancouver | Canada |