在执行代码前
在执行此代码后
delete from student where ROWID not in
(
select Max(rowid) from student
GROUP by stuname,stuage
HAVING (count(*)=1)
UNION
select Max(rowid) from student
GROUP by stuname,stuage
HAVING (count(*)>1)
);