Remove duplicates from table

From: trub3101 <trub3101_at_sky.com>
Date: Sat, 18 Apr 2009 06:01:32 -0700 (PDT)
Message-ID: <8845017a-4eb9-4d26-8aec-ba04d810d87a_at_k2g2000yql.googlegroups.com>



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 Received on Sat Apr 18 2009 - 08:01:32 CDT

Original text of this message