数据库删除重复数据

delete from student s1 where s1.rowid in (

           select s1.rowid

           from student s2

           where 

           s2.sid=s1.sid and

           s2.sname=s1.sname and

           s2.sex = s1.sex and

           s2.address = s1.address and

           s2.tid =s1.tid and

           s2.rowid>s1.rowid

    )