use MyDB
go
if OBJECT_ID('Stu','U') > 0
drop table Stu
create table Stu(
Id int identity(1,1) not null primary key,
[Name] nvarchar(20),
Course nvarchar(10),
Score int
)
insert into MyDB.dbo.Stu values('张三', '语文', 78)
insert into MyDB.dbo.Stu values('张三', '数学', 82)
insert into MyDB.dbo.Stu values('李四', '语文', 90)
insert into MyDB.dbo.Stu values('李四', '数学', 87)
select * from Stu
select Name from Stu group by Name having min(Score) > 80
SQL查询成绩大于某个值的所有学生姓名
最新推荐文章于 2022-11-12 13:16:36 发布