Re: Remove duplicates from table

"trub3101" <trub3101_at_sky.com> a écrit dans le message de news: 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 -

|

|

|

|

We will wait you'll post the correct requirements along with a complete test case (create table and insert statements) and the result you want with these test case data and your version of Oracle.

Regards
Michel Received on Sat Apr 18 2009 - 13:10:35 CDT