table name : temp AA BB
1 CAB 1009
2 CAB 1009
3 CAB 1009
4 CAC 2302
5 CAC 2302
6 CAC 2302处理后结果: AA BB
1 CAB 1009
2 CAB
3 CAB
4 CAC 2302
5 CAC
6 CAC
意思就是,将重复数据只显示一次,而且保留AA列的条数求高人解决,小生这里谢过..
1 CAB 1009
2 CAB 1009
3 CAB 1009
4 CAC 2302
5 CAC 2302
6 CAC 2302处理后结果: AA BB
1 CAB 1009
2 CAB
3 CAB
4 CAC 2302
5 CAC
6 CAC
意思就是,将重复数据只显示一次,而且保留AA列的条数求高人解决,小生这里谢过..
SELECT AA,DECODE(RN,1,BB,'') FROM
(SELECT AA
, BB
, ROW_NUMBER() OVER (PARTITION BY AA,BB ORDER BY BB) AS RN
FROM TMP)
SELECT AA,DECODE(RN,1,BB,'') FROM
(SELECT AA
, BB
, ROW_NUMBER() OVER (PARTITION BY AA,BB ORDER BY BB) AS RN
FROM TMP)
order by AA,RN