SqlServer排序检索

–第三章 排序检索

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; --以order_item为依据排序输出order_item列不重复数据
/*
order_item

1
2
3
4
5
*/