三：排序检索数据(ORDER BY)

admin

单列排序
SELECT 字段名 FROM 表名 ORDER BY 字段名;

1. SELECT prod_name FROM products ORDER BY prod_name;

复制代码

按多个列排序
SELECT 字段名1, 字段名2, 字段名3 FROM 表名 ORDER BY 字段名1, 字段名2;

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

复制代码

指定排序方向(默认升序:ASC,不写就是升序)
SELECT 字段名 FROM 表名 ORDER BY 字段名 DESC LIMIT 1;

1. SELECT prod_name FROM products ORDER BY prod_name DESC LIMIT 1;

复制代码