Name chengji fengshu
张三 数学 75
张三 语文 81
李四 数学 90
李四 语文 76
王五 数学 81
王五 语文 100
王五 英语 90
第1个回答 2010-08-30
select name from table a
where a.name not in (select name from table b where fengshu <=80)
where a.name not in (select name from table b where fengshu <=80)
第2个回答 2010-08-30
select name from *** where fenshu>80
第3个回答 2010-08-30
select name
from 表
group by chengji
having fengshu>80
from 表
group by chengji
having fengshu>80
第4个回答 2018-10-26
select distinct [Name] from [表] where [fengshu]>80
第5个回答 2018-03-28
select distinct [Name] from [表] where [Name] in (
select [Name] from [表] where [fengshu]>=80
)
select [Name] from [表] where [fengshu]>=80
)