sql server 中判斷分組排序的使用樣本

標籤：blog   sql   範圍   highlight   使用   排序   查詢   count   tab   

現在需要查詢一組資料，是對一欄欄位（column01）的資料分範圍查詢後分組排序：

select (casewhen [column01] >0 AND [column01]<= 500 THEN 1when [column01] >500 AND [column01]<= 1000 THEN 2when [column01] >1000 AND [column01]<= 5000 THEN 3when [column01] >5000 AND [column01]<= 20000 THEN 4when [column01] >20000 AND [column01]<= 40000 THEN 5else 0end) f,count(1) cnt from your_table WHERE [column01] > 0 group by (casewhen [column01] >0 AND [column01]<= 500 THEN 1when [column01] >500 AND [column01]<= 1000 THEN 2when [column01] >1000 AND [column01]<= 5000 THEN 3when [column01] >5000 AND [column01]<= 20000 THEN 4when [column01] >20000 AND [column01]<= 40000 THEN 5else 0end)

　　

sql server 中判斷分組排序的使用樣本