SQL数据重复显示的问题，如图

javon_liu 2015-11-01 12:05:43

请指导一下，谢谢

...全文

88 1 打赏收藏转发到动态举报

写回复

用AI写文章

1 条回复

切换为时间正序

请发表友善的回复…

发表回复

卖水果的net 版主 2015-11-01

打赏
举报


create table test(A varchar(10) , B varchar(10) , c int )
go
insert into test values
('AA','BB',1),
('AA','BB',2),
('CC','CC',3),
('CC','CC',4),
('CC','CC',5),
('CC','CC',6),
('D','D',7),
('D','D',8)
go
with m as (
select ROW_NUMBER() over(partition by A,B order by C) rn , * from test 
)
select case when rn =1 then A else '' end As A ,
       case when rn =1 then B else '' end As B,
       C 
  from m
go
drop table test 
go



(8 行受影响)
A          B          C
---------- ---------- -----------
AA         BB         1
                      2
CC         CC         3
                      4
                      5
                      6
D          D          7
                      8

(8 行受影响)