Re: Remove duplicates from table

From: trub3101 <trub3101_at_sky.com>
Date: Sat, 18 Apr 2009 06:59:55 -0700 (PDT)
Message-ID: <32d0330c-7d25-4dc4-aa1d-afb31d523f85_at_k41g2000yqh.googlegroups.com>

On 18 Apr, 14:40, trub3101 <trub3..._at_sky.com> wrote:
> On 18 Apr, 14:34, trub3101 <trub3..._at_sky.com> wrote:
>
>
>
>
>
> > On 18 Apr, 14:01, trub3101 <trub3..._at_sky.com> 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
>
> > Hi all,
>
> > Sorry, my bad! The schema is actually has two tables the other being:
>
> > test2
> > test2_id number(10) pk
> > name varchar2(100)
>
> > 134|cricket
> > 367|football
> > 552|golf
>
> > So
>
> > 1|367|19/04/2009 17:15|19/04/2009 20:00
> > 2|367|19/04/2009 17:15|19/04/2009 20:00
> > 3|367|19/04/2009 17:15|19/04/2009 20:00
> > 4|367|19/04/2009 17:15|19/04/2009 20:00
> > 6|134|19/04/2009 13:15|19/04/2009 22:00
> > 7|134|19/04/2009 13:15|19/04/2009 22:00
> > 8|134|19/04/2009 13:15|19/04/2009 22:00
> > 9|134|19/04/2009 13:15|19/04/2009 22:00
>
> > becomes;
>
> > 1|367|19/04/2009 17:15|19/04/2009 20:00
> > 6|367|19/04/2009 13:15|19/04/2009 22:00- Hide quoted text -
>
> > - Show quoted text -
>
> My bad again!
>
> 1|367|19/04/2009 17:15|19/04/2009 20:00
> 6|367|19/04/2009 13:15|19/04/2009 22:00 should be:
>
> 1|367|19/04/2009 17:15|19/04/2009 20:00
> 6|134|19/04/2009 13:15|19/04/2009 22:00
>
> Think that's it!
>
> Thanks in advance
>
> tb3101- Hide quoted text -
>
> - Show quoted text -

Okay everyone,

I have decided to close this thread because the details I have submitted is not quite correct.

I will re-submit when I have the full facts.

Sorry about this but please do not bother to reply to this post!!!

Thanks tb3101 Received on Sat Apr 18 2009 - 08:59:55 CDT