MySQL必知必会第5章——排序检索数据

1. 排序数据

SELECT prod_name
FROM products
ORDER BY prod_name;

SELECT和ORDER BY后面接的列不一定要相同

SELECT prod_name
FROM products
ORDER BY prod_price;

2. 按多个列排序

SELECT prod_id, prod_price, prod_name
FROM products
ORDER BY prod_price, prod_name;

3. 指定排序方向

SELECT prod_id, prod_price, prod_name
FROM products
ORDER BY prod_price DESC;

注意DESC只对前面的列有效，如果要对全部列降序排序，则需要在每个列后面都加上DESC

4. 找出最大值

SELECT prod_price
FROM products
ORDER BY prod_price DESC
LIMIT 1;