query needed

  • From: Mohammed Mehraj hussain <mhdmehraj@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 18 May 2009 11:28:21 +0530

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: