query needed

From: Mohammed Mehraj hussain <mhdmehraj_at_gmail.com>
Date: Mon, 18 May 2009 11:28:21 +0530
Message-ID: <b081c0a50905172258i25da4d18ja4a0a4cd03480663_at_mail.gmail.com>

Hi Everybody,

I have a table with this columns

For Eg:

Table Name: emp


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.

Mohammed Mehraj Hussain

http://www.freelists.org/webpage/oracle-l Received on Mon May 18 2009 - 00:58:21 CDT

Original text of this message