sql语句删除重复记录(oracle)

select * from login a

where rowid!=(selectmin(rowid) from login b where a.username=b.username)

deletefrom login a

where rowid!=(selectmax(rowid) from login b where a.username=b.username)