On Thursday, May 03, 2012 09:05:38 PM Ricardo Araoz wrote:

> El 03/05/12 10:05, John Fabiani escribió:

> > On Thursday, May 03, 2012 07:15:46 AM Ricardo Araoz wrote:

> >> Don't know if I understood what you want. I think you want to get rid

> >> of

> >> duplicate records.

> >> It it is so, then in SQL is really simple :

> >>

> >> select distinct * from TheTable

> >>

> >> T t t t that's all folks.

> >

> > He wants all the dups removed but the last one.

> >

> > Johnf

>

> So I was right (the last one is the same as any other dup) the "select

> distinct" will do it easily.

As I understand it all but the last one - using distinct does not insure the

LAST ONE is saved. How he finds the last I'm not sure.

Johnf

_______________________________________________

Post Messages to: Dabo-users@leafe.com

Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users

Searchable Archives: http://leafe.com/archives/search/dabo-users

This message: http://leafe.com/archives/byMID/1935844.tM7pu1bqSp@linux-12