sqlquery7.sql

来自「经典的SOL面试题,涵盖了数据库各个层面的问题和答案。」· SQL 代码 · 共 33 行

/*
use test
go
create table myscore
(
studentname varchar(10) not null ,
classname varchar(10),
grade int
)


insert  myscore select '1','m',80
--insert into myscore(studentname,classname,grade) values( '4','n',98)
insert  myscore select '1','n',87
insert  myscore select '1','o',46
insert  myscore select '2','m',87
insert  myscore select '2','n',87
insert  myscore select '2','o',78
insert  myscore select '3','m',78
insert  myscore select '3','n',38
insert  myscore select '3','o',78
insert  myscore select '4','m',98

*/
--求出各科成绩都大于75分的学生
select * from myscore
select * from myscore
where studentname in (
select studentname
from myscore
group by studentname  
having min(grade)>75)