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,
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
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
Received on Mon May 18 2009 - 00:58:21 CDT