一道大宇宙公司面试题

发布网友 发布时间：2022-05-27 20:19

我来回答

共4个回答

热心网友 时间：2024-11-03 19:01

if exists(select name from sysobjects where name = 'Score')
drop table Score
go
create table Score
(
[name] varchar(10),
class varchar(10),
grade float
)
go

insert Score([name],class,grade) values('张三','数学',81)
insert Score([name],class,grade) values('李四','语文',70)
insert Score([name],class,grade) values('王五','数学',90)
insert Score([name],class,grade) values('张三','语文',60)
insert Score([name],class,grade) values('李四','数学',100)
insert Score([name],class,grade) values('王五','语文',90)
insert Score([name],class,grade) values('王五','英语',81)

select * from Score

select name from Score where name not in (select name from Score where grade < 80) group by name

热心网友 时间：2024-11-03 19:02

select name from Score where name not in (select name from Score where grade < 80) group by name

热心网友 时间：2024-11-03 19:02

select distinct name from Score where name not in
(select name from Score where grade < 80) ;

热心网友 时间：2024-11-03 19:03

select name from Score where name not in (select name from Score where grade<80)