ÇóSQL Óï¾ä - MS-SQL Server / »ù´¡Àà

±í Ãû:table
×Ö¶Î
ÐÕÃû ѧ¿Æ ·ÖÊý
ÕÅÈý ÓïÎÄ 65
ÕÅÈý Êýѧ 80
ÀîËÄ ÓïÎÄ 75
ÀîËÄ Êýѧ 81
ÀîËÄ ÎïÀí 67 
ÍõÎå ÓïÎÄ 81
ÍõÎå Êýѧ 85
ÍõÎå ÎïÀí 91
²ÌÁù ÓïÎÄ 83
²ÌÁù Êýѧ 90
²ÌÁù ÎïÀí 92

²é³ö ÓïÎÄ ´óÓÚ 70 ²¢ÇÒÊýѧ ´óÓÚ 80 ²¢ÇÒ ÎïÀí´óÓÚ 90 ѧÉú µÄ ÐÕÃû
ÇóSQL Óï¾ä£¨×îºÃЧÂÊÓָߵĹþ£¬Ð»Ð»ÏÈ)


---²âÊÔÊý¾Ý---
if object_id('[table]') is not null drop table [table]
go
create table [table]([ÐÕÃû] varchar(4),[ѧ¿Æ] varchar(4),[·ÖÊý] int)
insert [table]
select 'ÕÅÈý','ÓïÎÄ',65 union all
select 'ÕÅÈý','Êýѧ',80 union all
select 'ÀîËÄ','ÓïÎÄ',75 union all
select 'ÀîËÄ','Êýѧ',81 union all
select 'ÀîËÄ','ÎïÀí',67 union all
select 'ÍõÎå','ÓïÎÄ',81 union all
select 'ÍõÎå','Êýѧ',85 union all
select 'ÍõÎå','ÎïÀí',91 union all
select '²ÌÁù','ÓïÎÄ',83 union all
select '²ÌÁù','Êýѧ',90 union all
select '²ÌÁù','ÎïÀí',92

---

SQL code:
select name from tb t where not exists(select 1 from tb where name=t.name and ÓïÎÄ<=70 and Êýѧ<=80 and ÎïÀí<=90)

---

ÒýÓÃ

SQL code
select name from tb t where not exists(select 1 from tb where name=t.name and ÓïÎÄ<=70 and Êýѧ<=80 and ÎïÀí<=90)

СF,Äã˵µÄÊÇ£º

SQL cod