日期:2014-05-18  浏览次数:20382 次

求SQL,急,在线
ID CODE
5 02Y1111
6 02Y1111
10 02Y1111
16 02Y1111
17 02Y1111
18 02Y1111

求一条DELETE的SQL,后变为
ID CODE
5 02Y1111
10 02Y1111
16 02Y1111

意思是相连的ID,只要第一条。

------解决方案--------------------
SQL code

declare @t table (ID int,CODE varchar(7))
insert into @t
select 5,'02Y1111' union all
select 6,'02Y1111' union all
select 10,'02Y1111' union all
select 16,'02Y1111' union all
select 17,'02Y1111' union all
select 18,'02Y1111'

select * from @t where ID in(
select min(ID) from (select *,rid=(select count(1) from @t where ID<=a.ID) 
from @t a) b group by ID-rid)

/*
ID          CODE
----------- -------
5           02Y1111
10          02Y1111
16          02Y1111
*/