delete from student a where not exists (select 1 from student b group by b.stuno, b.stuname, b.course, b.score having min(b.id) = a.id);