22,207
社区成员
发帖
与我相关
我的任务
分享
SELECT LEFT(t.value,1)+'-'+CAST(left(t.value,1)+1 AS VARCHAR),SUM(t.count)
FROM (
SELECT value,COUNT(*) AS count
FROM t1
GROUP BY value) AS t
GROUP BY LEFT(t.value,1)+'-'+CAST(left(t.value,1)+1 AS VARCHAR)
/*
--------------------------------- -----------
1-2 231904
2-3 245728
3-4 247712
4-5 244128
5-6 247392
6-7 245120
7-8 244512
8-9 250560
9-10 244480
*/
SELECT t.id+'-'+CAST(t.id+1 AS VARCHAR),t.count
FROM (
SELECT LEFT(value,1) AS id,COUNT(*) AS count
FROM t1
GROUP BY LEFT(value,1)) AS t
ORDER BY t.id
/*
region count
--------------------------------- -----------
1-2 231904
2-3 245728
3-4 247712
4-5 244128
5-6 247392
6-7 245120
7-8 244512
8-9 250560
9-10 244480
*/
SELECT LEFT(value,1)+'-'+LEFT(value+1,1),COUNT(*)
FROM t1
GROUP BY LEFT(value,1)+'-'+LEFT(value+1,1)
select convert(varchar(2),[value]%10)+'-'+convert(varchar(2),[value]%10+1) Region,count(*) Count from [你的表]
group by [value]%10
SELECT '1-2' ,COUNT(1) AS count
FROM tablename
WHERE VALUE >= 1 AND VALUE< 2
UNION ALL