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,
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