MySQL排序检索数据order by

1. MySQL排序检索数据

排序数据
SQL> select prod_name from products order by prod_name;

按多个列排序
SQL> select prod_id, prod_price, prod_name from products order by prod_price, prod_name;

指定排序方向
SQL> select prod_id, prod_price, prod_name from products order by prod_price DESC;

多字段排序
SQL> select prod_id, prod_price, prod_name from products order by prod_price DESC, prod_name ASC;

使用order by和limit查找最高最低值
SQL> select prod_price from products order by prod_price DESC limit 1;