Re: query needed

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

Other related posts: