取表中以某几个字段连续相同的数据的第一条数据

chuanzhang5687

于 2013-03-27 13:50:03 发布

阅读量1k

点赞数

CC 4.0 BY-SA版权

文章标签： sql server

本文链接：https://blog.youkuaiyun.com/chuanzhang5687/article/details/8726254

create table tb(id int identity(1,1),name nvarchar(10),age int)
insert into tb(name,age) values('jack',20)
insert into tb(name,age) values('king',21)
insert into tb(name,age) values('king',21)
insert into tb(name,age) values('lili',19)
insert into tb(name,age) values('lili',20)
insert into tb(name,age) values('lili',20)
insert into tb(name,age) values('lili',19)
 
select * from tb


1	jack	20
2	king	21
3	king	21
4	lili	19
5	lili	20
6	lili	20
7	lili	19
 


Select id, name, age From tb A Where Not Exists(Select ID From tb Where name = A.NAME AND age=A.age And ID = A.ID - 1)


1	jack	20
2	king	21
4	lili	19
5	lili	20
7	lili	19