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: [email protected] 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
