关于如何解决SQL分段查询,数据库中有数据
ID AGE
1 1
2 2
3 1
4 2
5 3
6 3
7 3
8 4
9 5
10 10
要查询出以下结果
1-3 4
3-4 4
4- 2
我的解决方法是:
SQL语句:
select
case when (age >=1 and age <3) then '1-3'
when (age >=3 and age <=4) then '3-4' else '4-' end 'eag_layer', count(age) from agge
group by
case when (age >=1 and age <3) then '1-3' when (age >=3 and age <=4) then '3-4' else '4-' end order by 1