27,579
社区成员
发帖
与我相关
我的任务
分享
/*
create database temp
use temp
create table employees
(
eID int identity primary key,
eName nvarchar(50) not null,
eSex smallint not null default(1),
eSort smallint default(0)
)
insert into employees values('a1',1,1);
insert into employees values('b5',0,5);
insert into employees values('a6',0,6);
insert into employees values('b3',1,3);
insert into employees values('a1',1,7);
insert into employees values('b5',0,9);
insert into employees values('a6',0,10);
insert into employees values('b3',1,20);
*/
select * from [employees] a
where not exists
(select 1 from [employees] where ename=a.ename and eSex=a.eSex and eSort>a.eSort)
/*
5 a1 1 7
6 b5 0 9
7 a6 0 10
8 b3 1 20
*/