Re: [dabo-users] Migration from dBaseIII+ & SQL/Client interaction

Author: Ricardo Araoz

Posted: 2012-05-03 at 19:05:38

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.

_______________________________________________

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/4FA31D52.3020200@gmail.com

©2012 Ricardo Araoz