SQL 必知必会第三课 排序检索数据

SQL 必知必会第三课 排序检索数据

Select prod_name From Products; -- 上一节课学的选出列
Select prod_name From Products Order By prod_name; -- 以字母顺序排列数据
Select prod_id, prod_price, prod_name From Products Order By prod_price, prod_name; 
## 先对price进行排序，随和相同p用名字进行排序
Select prod_id, prod_price, prod_name From Products Order By 2,3 ;
## 将相对列位置进行排序 与上一条语句结果相同
Select prod_id, prod_price, prod_name From Products Order By prod_price DESC;
## 对price进行降序排列
Select prod_id, prod_price, prod_name From Products Order By prod_price DESC, prod_name;
## 对price进行降序排列之后对产品名字进行排序

##Challenges 
select cust_name from Customers order by cust_name desc; -- 1
select cust_id, order_num from Orders order by cust_id, order_num desc; -- 2
select quantity, item_price from OrderItems order by quantity desc, item_price desc; -- 3

注意点

1. order by 必须是select的最后一条字句

2. 用相对列位置进行排序时，列的位置不在select清单中，无法进行排序

3. 若想进行多个列上降序排序，必须对每一列加上关键词DESC