Hi Everybody, I have a table with this columns For Eg: Table Name: emp eno ename salary date ----------------------------- In eno i dont have primary key as well as unique index , so i got duplicate records in my table , so i need to check the table with the eno column , If any eno is repeted then i need to delete one of those eno. so , Plz provide a query to check the above case. Rehgards, Mohammed Mehraj Hussain -- //www.freelists.org/webpage/oracle-l