–第三章 排序检索
select order_item
from OrderItems
order by order_item; --以order_item为依据排序输出对应列
/*
order_item
1
1
1
1
1
2
2
2
2
2
3
3
3
3
4
4
5
5
*/
select order_item,prod_id
from OrderItems
order by prod_id; --以prod_id为依据排序输出order_item,prod_id两列数据
/*
order_item prod_id
2 BNBG01
3 BNBG01
1 BNBG01
2 BNBG02
4 BNBG02
3 BNBG02
4 BNBG03
5 BNBG03
3 BNBG03
1 BR01
1 BR01
2 BR02
3 BR03
1 BR03
2 BR03
2 BR03
5 RGAN01
1 RGAN01
*/
select distinct order_item
from OrderItems
order by order_item;