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 表名 where fenshu<80);
查询出每门课都大于80分的学生姓名【杭州多测师】【杭州多测师_王sir】
最新推荐文章于 2023-08-21 16:19:46 发布