不定区间的范围分组统计WITHTAS(SELECT1NFROMDUALUNIONALLSELECT3NFROMDUALUNIONALLSELECT4NFROMDUALUNIONALLSELECT7NFROMDUALUNIONALLSELECT10NFROMDUALUNIONALLSELECT11NFROMDUALUNIONALLSELECT12NFROMD

Question

不定区间的范围分组统计
WITH T AS (
SELECT 1 N FROM DUAL UNION ALL
SELECT 3 N FROM DUAL UNION ALL
SELECT 4 N FROM DUAL UNION ALL
SELECT 7 N FROM DUAL UNION ALL
SELECT 10 N FROM DUAL UNION ALL
SELECT 11 N FROM DUAL UNION ALL
SELECT 12 N FROM DUAL UNION ALL
SELECT 12 N FROM DUAL UNION ALL
SELECT 19 N FROM DUAL UNION ALL
SELECT 20 N FROM DUAL
)
SELECT N FROM T;
N
----------
1
3
4
7
10
11
12
19
20
求如下分组如何写,相对小于5为一组.
5 一组,11 一组,12~16一组,19~23 一组
因为没有6,7开始5之内为一组,后面也是.
N G
---------- ----------
1 1
3 1
4 1
7 2
10 2
11 2
12 3
12 3
19 4
20 4

Answer 1

先给个MODEL的写法,然后是普通的//////////////////////////WITH T AS (SELECT 1 N FROM DUAL UNION ALL SELECT 3 N FROM DUAL UNION&...