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 @tselect 5,'02Y1111' union allselect 6,'02Y1111' union allselect 10,'02Y1111' union allselect 16,'02Y1111' union allselect 17,'02Y1111' union allselect 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 02Y111110 02Y111116 02Y1111*/