delete from S1_COURSE
where cno in(
select
CNO
from S1_COURSE
group by CNO
having count(CNO)>1
);
操作以后
select * from S1_COURSE;
delete from S1_COURSE
where cno in(
select
CNO
from S1_COURSE
group by CNO
having count(CNO)>1
);
操作以后
select * from S1_COURSE;