Re: query needed
- From: Karl Arao <karlarao@xxxxxxxxx>
- To: mhdmehraj@xxxxxxxxx
- Date: Mon, 18 May 2009 14:52:29 +0800
I recommend you read this
http://www.devx.com/getHelpOn/10MinuteSolution/16597/1954
- Karl Arao
http://karlarao.wordpress.com
On Mon, May 18, 2009 at 1:58 PM, Mohammed Mehraj hussain <
mhdmehraj@xxxxxxxxx> wrote:
> 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
>
>
>
Other related posts: