query needed

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
--
http://www.freelists.org/webpage/oracle-l


Other related posts: