题目:将挨在一起的CNAME分为一组,计算每条数据对应的分组,具体输入和要求的输出如下:
数据输入:
CNMAE | ID |
---|---|
A | 1 |
A | 2 |
B | 3 |
A | 4 |
A | 5 |
A | 6 |
A | 7 |
D | 8 |
D | 9 |
D | 10 |
B | 11 |
A | 12 |
需要得到的输出:
CNMAE | ID | Group |
---|---|---|
A | 1 | 1 |
A | 2 | 1 |
B | 3 | 2 |
A | 4 | 3 |
A | 5 | 3 |
A | 6 | 3 |
A | 7 | 3 |
D | 8 | 4 |
D | 9 | 4 |
D | 10 | 4 |
B | 11 | 5 |
A | 12 | 6 |
数据准备:
create table ods.temp as
select 'A' as cname,1 as id
union all
select 'A' as cname,