ÇóSQLÓï¾ä£¡ - .NET¼¼Êõ / ASP.NET

ÎҵıíÈçÏ£º

A B C D E F
ÕÅÈý 1 1 1 1 4 4
ÕÅÈý 1 1 1 1 4 6
ÀîËÄ 1 1 1 2 3 4
ÀîËÄ 1 1 1 2 3 8
ÀîËÄ 1 1 5 1 4 15
ÍõÎå 1 1 1 1 4 4
ÍõÎå 1 1 1 1 4 7
ÕÔÁù 1 1 1 3 4 10


ÎÒÏëÈ¡±íÖÐÿ¸öÈËF×Ö¶ÎÀïÃæ×î´óµÄÄÇÌõÊý¾Ý

ÀíÏë½á¹ûÈçÏ£º
ÕÅÈý 1 1 1 1 4 6
ÀîËÄ 1 1 5 1 4 15
ÍõÎå 1 1 1 1 4 7
ÕÔÁù 1 1 1 3 4 10

ÇóSQLÓï¾ä£¡
лл£¡

---

SQL code:
create table #TT1
(
A nvarchar(20),
B int,
C int,
D int,
E int,
F int,
G int
)
insert into #TT1 select 'ÕÅÈý',1,1,1,1,4,4
insert into #TT1 select 'ÕÅÈý',1,1,1,1,4,6
insert into #TT1 select 'ÀîËÄ',1,1,1,1,4,4
insert into #TT1 select 'ÀîËÄ',1,1,1,1,4,8
insert into #TT1 select 'ÀîËÄ',1,1,1,1,4,15
insert into #TT1 select 'ÍõÎå',1,1,1,1,4,4
insert into #TT1 select 'ÍõÎå',1,1,1,1,4,7
insert into #TT1 select 'ÕÔÁù',1,1,1,3,4,10

select * from #TT1 T where not exists(select * from #TT1 where A=T.A and G>T.G)

A B C D E F G
-------------------- ----------- ----------- ----------- ----------- ----------- -----------
ÕÅÈý 1 1 1 1 4 6
ÀîËÄ 1 1 1 1 4 15
ÍõÎå 1 1 1