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

Author: Dennis Lee Bieber

Posted: 2012-05-03 at 21:26:52

On Thu, 03 May 2012 21:05:38 -0300, Ricardo Araoz

<ricaraoz@gmail.com> declaimed the

following in gmane.comp.python.dabo.user:

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

Not quite... The specification was that the ordering was

MD5-path-file, but duplicates were only determined by MD5.

--

Wulfraed Dennis Lee Bieber AF6VN

wlfraed@ix.netcom.com HTTP://wlfraed.home.netcom.com/

_______________________________________________

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/ihf6q75ms9i45kdeq6djidlihs3bv0b6na@invalid.netcom.com

©2012 Dennis Lee Bieber