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