ORDER BY
- ORDER BY语句用于根据指定的列对结果集进行排序。
- ORDER BY语句默认按照升序对记录进行排序。
- 降序排序可以用DESC关键字。
VIN | BRAND | MODEL | PRICE | PRODUCTION_YEAR |
---|
LJCPCBLCX14500264 | Ford | Focus | 8000 | 2005 |
WPOZZZ79ZTS372128 | Ford | Fusion | 10000 | 2008 |
JF1BR93D7BG498281 | Toyota | Avensis | 10000 | 1999 |
KLATF08Y1VB363636 | Volkswagen | Golf | 3000 | 1992 |
1M8GDM9AXKP042788 | Volkswagen | Golf | 10000 | 2010 |
1HGCM82633A004352 | Volkswagen | Jetta | 6000 | 2003 |
1G1YZ23J9P5800003 | Fiat | Punto | 6000 | 1999 |
GS723HDSAK2399002 | Opel | Corsa | null | 2007 |
- 查询表中的数据并且按照BRAND排序(使用ORDER BY),
SELECT * FROM CAR ORDER BY BRAND;
VIN | BRAND | MODEL | PRICE | PRODUCTION_YEAR |
---|
1G1YZ23J9P5800003 | Fiat | Punto | 5700.00 | 1999 |
WPOZZZ79ZTS372128 | Ford | Fusion | 12500.00 | 2008 |
LJCPCBLCX14500264 | Ford | Focus | 8000.00 | 2005 |
GS723HDSAK2399002 | Opel | Corsa | null | 2007 |
JF1BR93D7BG498281 | Toyota | Avensis | 11300.00 | 1999 |
1HGCM82633A004352 | Volkswagen | Jetta | 6420.00 | 2003 |
1M8GDM9AXKP042788 | Volkswagen | Golf | 13000.00 | 2010 |
KLATF08Y1VB363636 | Volkswagen | Golf | 3270.00 | 1992 |
- 字母排序按照商标BRAND,并以数字PRICE顺序显示顺序号:
SELECT BRAND , PRICE FROM CAR ORDER BY BRAND , PRICE;
BRAND | PRICE |
---|
Fiat | 5700.00 |
Ford | 12500.00 |
Ford | 8000.00 |
Opel | null |
Toyota | 11300.00 |
Volkswagen | 6420.00 |
Volkswagen | 13000.00 |
Volkswagen | 3270.00 |
SELECT BRAND , PRICE FROM CAR ORDER BY BRAND DESC;
BRAND | PRICE |
---|
Volkswagen | 3270.00 |
Volkswagen | 6420.00 |
Volkswagen | 13000.00 |
Toyota | 11300.00 |
Opel | null |
Ford | 12500.00 |
Ford | 8000.00 |
Fiat | 5700.00 |
SELECT BRAND,PRICE FROM CAR ORDER BY BRAND DESC,PRICE ASC;
BRAND | PRICE |
---|
Volkswagen | 3270.00 |
Volkswagen | 6420.00 |
Volkswagen | 13000.00 |
Toyota | 11300.00 |
Opel | null |
Ford | 8000.00 |
Ford | 12500.00 |
Fiat | 5700.00 |