table name : tempspa
AA BB
1 CAB 1009
2 CAB 1009
3 CAB 1009
4 CAC 2302
5 CAC 2302
6 CAC 2302table
处理后结果:数据
AA BB
1 CAB 1009
2 CAB
3 CAB
4 CAC 2302
5 CAC
6 CAC
意思就是,将重复数据只显示一次,并且保留AA列的条数tab
SELECT AA,DECODE(RN,1,BB,'') FROM
(SELECT AA
, BB
, ROW_NUMBER() OVER (PARTITION BY AA,BB ORDER BY BB) AS RN
FROM TEMP)
order by AA,RNab