sql server 中判断分组排序的使用示例
select (casewhen >0 AND <= 500 THEN 1
when >500 AND <= 1000 THEN 2
when >1000 AND <= 5000 THEN 3
when >5000 AND <= 20000 THEN 4
when >20000 AND <= 40000 THEN 5
else 0
end) f,
count(1) cnt from your_table WHERE > 0 group by
(case
when >0 AND <= 500 THEN 1
when >500 AND <= 1000 THEN 2
when >1000 AND <= 5000 THEN 3
when >5000 AND <= 20000 THEN 4
when >20000 AND <= 40000 THEN 5
else 0
end)
页:
[1]