首页 > 其他分享 >查询出每门课都大于80分的学生姓名【杭州多测师】【杭州多测师_王sir】

查询出每门课都大于80分的学生姓名【杭州多测师】【杭州多测师_王sir】

时间:2022-10-26 11:00:51浏览次数:46  
标签:sir 多测师 name kecheng fengshu table 杭州 where select

查询出每门课都大于80分的学生姓名【杭州多测师】【杭州多测师_王sir】_表名

 

1.1  
select fengshu from table where name="张三" and kecheng="语文";
1.2
update table set fengshu=23 where name="张三" and kecheng="语文";
1.3
delete from table where name="王五" and kecheng="语文 and fengshu=35"
1.4
insert into table values(4,"王五","物理",35)
1.5
select * from table order by fengshu desc;
1.6
答案一:
select name from 表名 group by name having min(fenshu)>80;
答案二:
select name from 表名 group by name having name not in (select name from

 



标签:sir,多测师,name,kecheng,fengshu,table,杭州,where,select
From: https://blog.51cto.com/u_15846941/5797427

相关文章