表如下:
列1 列2 列3 列4
A B C D
A H I J
A H I K
F D D E
F I J K
F I K K
得到以下的查询结果:
列1 列2 列3 列4
A B C D
H I J
I K
F D D E
I J K
K i
列1 列2 列3 列4
A B C D
A H I J
A H I K
F D D E
F I J K
F I K K
得到以下的查询结果:
列1 列2 列3 列4
A B C D
H I J
I K
F D D E
I J K
K i
调试欢乐多
(
A1 varchar(10),
A2 varchar(10),
A3 varchar(10),
A4 varchar(10)
)insert A select 'A','B','C','D'
insert A select 'A','H','I','J'
insert A select 'A','H','I','K'
insert A select 'F','D','D','E'
insert A select 'F','I','J','K'
insert A select 'F','I','K','K'
select identity(int,1,1) as id,* into # from A
select case when T_id=1 then A1
when T_id=2 then ''
when T_id=3 then '' end as A1,
case when T_id=1 then A2
when T_id=2 then A2
when T_id=3 then '' end as A2,
A3,A4 from
(select (select count(*) from # where A1=T.A1 and id<=T.id) as T_id ,T.* from # T) M