数据库：数据删除

52） 删除T_STUDENT表中的女生记录
delete
from T_student
where stusex=’女’;

53） 删除T_COURSE表中的全部记录
先新建一张表:
create table T_course1(courseno varchar2(16),coursename varchar2(16),teano varchar2(16));

delete
from T_course1;

54） 删除女生的分数记录
delete
from T_score
where T_score.stuno in (select T_score.stuno
from T_student,T_score
where T_score.stuno=T_student.stuno and T_student.stusex=’女’
);