Re: query needed

• Karl Arao http://karlarao.wordpress.com

On Mon, May 18, 2009 at 1:58 PM, Mohammed Mehraj hussain < mhdmehraj_at_gmail.com> 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
>
>
>

--
http://www.freelists.org/webpage/oracle-l