ORDER BY

ORDER BY语句用于根据指定的列对结果集进行排序。ORDER BY语句默认按照升序对记录进行排序。降序排序可以用DESC关键字。

---

原始表: VINBRANDMODELPRICEPRODUCTION_YEARLJCPCBLCX14500264FordFocus80002005WPOZZZ79ZTS372128FordFusion100002008JF1BR93D7BG498281ToyotaAvensis100001999KLATF08Y1VB363636VolkswagenGolf300019921M8GDM9AXKP042788VolkswagenGolf1000020101HGCM82633A004352VolkswagenJetta600020031G1YZ23J9P5800003FiatPunto60001999GS723HDSAK2399002OpelCorsanull2007

---

查询表中的数据并且按照BRAND排序(使用ORDER BY)， SELECT * FROM CAR ORDER BY BRAND; VINBRANDMODELPRICEPRODUCTION_YEAR1G1YZ23J9P5800003FiatPunto5700.001999WPOZZZ79ZTS372128FordFusion12500.002008LJCPCBLCX14500264FordFocus8000.002005GS723HDSAK2399002OpelCorsanull2007JF1BR93D7BG498281ToyotaAvensis11300.0019991HGCM82633A004352VolkswagenJetta6420.0020031M8GDM9AXKP042788VolkswagenGolf13000.002010KLATF08Y1VB363636VolkswagenGolf3270.001992

---

字母排序按照商标BRAND，并以数字PRICE顺序显示顺序号: SELECT BRAND , PRICE FROM CAR ORDER BY BRAND , PRICE; BRANDPRICEFiat5700.00Ford12500.00Ford8000.00OpelnullToyota11300.00Volkswagen6420.00Volkswagen13000.00Volkswagen3270.00

---

以逆字母顺序显示商标 SELECT BRAND , PRICE FROM CAR ORDER BY BRAND DESC; BRANDPRICEVolkswagen3270.00Volkswagen6420.00Volkswagen13000.00Toyota11300.00OpelnullFord12500.00Ford8000.00Fiat5700.00

---

逆字母显示商标，并且以价格数字顺序显示。 SELECT BRAND,PRICE FROM CAR ORDER BY BRAND DESC,PRICE ASC; BRANDPRICEVolkswagen3270.00Volkswagen6420.00Volkswagen13000.00Toyota11300.00OpelnullFord8000.00Ford12500.00Fiat5700.00

---