SQL高级查询(三)

2014-11-23 22:26:50 · 作者: · 浏览: 41
_score

where grade <60 group by sid having count(*)>2

)

group by sid;
49、检索“004”课程分数小于60,按分数降序排列的同学学号
select sid from t_score where cid='004'and grade <60 order by grade desc;
50、删除“002”同学的“001”课程的成绩
delete from t_score where sid='001'and cid = '001';