TABLE AA ID AA BB CC DD EE
1 11 Y tt uu xx
2 11 Y oo bb jj
3 12 C 00 99 88
4 12 C 33 44 55
5 13 U .. .. ..
6 14 X .. .. ..要得到这样的数据集
ID AA BB CC DD EE
1 11 Y tt uu xx3 12 C 00 99 885 13 U .. .. ..
6 14 X .. .. ..
求 哥哥些给提示
1 11 Y tt uu xx
2 11 Y oo bb jj
3 12 C 00 99 88
4 12 C 33 44 55
5 13 U .. .. ..
6 14 X .. .. ..要得到这样的数据集
ID AA BB CC DD EE
1 11 Y tt uu xx3 12 C 00 99 885 13 U .. .. ..
6 14 X .. .. ..
求 哥哥些给提示
1 11 Y tt uu xx
3 12 C 00 99 88
5 13 U .. .. ..
6 14 X .. .. ..
from AA T
WHERE T.ID in (select top 1 id from AA group by AA)
FROM AA A
WHERE NOT EXISTS (SELECT 1
FROM AA
WHERE AA = A.AA
AND BB = A.BB
AND ID < A.ID)
select * from 表名 T where not exists(select * from 表名 where ID< T.ID AND AA=T.AA)
Declare @Tb table(ID int,AA varchar(10),BB varchar(10),CC varchar(10),DD varchar(10),EE varchar(10))
insert into @Tb SELECT 1,'11', 'Y', 'tt', 'uu', 'xx'
UNION ALL SELECT 2,'11', 'Y','oo', 'bb','jj'
UNION ALL SELECT 3,'12', 'C ', '00', '99', '88'
UNION ALL SELECT 4, '12', 'C', '33', '44', '55'
UNION ALL SELECT 5,'13', 'U ', '..' , '..', '..'
UNION ALL SELECT 6,'14','X', '..', ' ..', '..'select * from @Tb
--查詢語句
select * from @Tb T where not exists(select * from @Tb where ID< T.ID AND AA=T.AA)
/* 結果ID AA BB CC DD EE
----------- ---------- ---------- ---------- ---------- ----------
1 11 Y tt uu xx
3 12 C 00 99 88
5 13 U .. .. ..
6 14 X .. .. ..(所影响的行数为 4 行)
*/ --完成--