Re: Remove duplicates from table

From: Michael Austin <maustin_at_firstdbasource.com>
Date: Sat, 18 Apr 2009 21:34:21 -0500
Message-ID: <63wGl.19217$as4.5744_at_nlpi069.nbdc.sbc.com>



trub3101 wrote:
> Hi Guys,
>
> Could really do with you assistance here!
>
>
> I have table test
>
> test_id number(11) PK
> test_name varchar2(100)
> start_time date
> end_time date
>
> In essence I need remove the duplicate records from the table so that:
>
> 1|football|19/04/2009 17:15|19/04/2009 20:00
> 2|football|19/04/2009 17:15|19/04/2009 20:00
> 3|football|19/04/2009 17:15|19/04/2009 20:00
> 4|football|19/04/2009 17:15|19/04/2009 20:00
> 6|cricket|19/04/2009 13:15|19/04/2009 22:00
> 7|cricket|19/04/2009 13:15|19/04/2009 22:00
> 8|cricket|19/04/2009 13:15|19/04/2009 22:00
> 9|cricket|19/04/2009 13:15|19/04/2009 22:00
>
> becomes;
>
> 1|football|19/04/2009 17:15|19/04/2009 20:00
> 6|cricket|19/04/2009 13:15|19/04/2009 22:00
>
> Your help would truly appreciated with this one!
>
> Thanks in advance,
>
> tb3101
>
>
>

or you could just http://lmgtfy.com/?q=oracle+remove+duplicate+join Received on Sat Apr 18 2009 - 21:34:21 CDT

Original text of this message