Doh! Sorry, please move along, nothing to see here:
SELECT SelectId, MAX( DTime) FROM DBF() TO SCREEN GROUP BY 1 Boy, did I pick a bad week to stop sniffing glue. G. On Jan 24, 2008 5:18 PM, Garry Bettle <[EMAIL PROTECTED]> wrote: > Howdy all, > > Hope this email finds everyone well - roll on the weekend. > > I'm trying to work out how to select the latest row from a database, based > on the latest datetime field. > > So, if I have something like: > > Id Datetime > ------- ------------------- > 1412554 24/01/2008 14:09:10 > 1412554 24/01/2008 14:09:24 > 1412554 24/01/2008 14:09:31 > 1519040 24/01/2008 14:04:29 > 736856 24/01/2008 14:00:50 > 736856 24/01/2008 14:01:05 > 736856 24/01/2008 14:01:26 > 736856 24/01/2008 14:08:17 > 805539 24/01/2008 13:48:46 > 805539 24/01/2008 13:55:03 > 805539 24/01/2008 13:56:16 > 805539 24/01/2008 14:04:37 > 805539 24/01/2008 14:06:12 > 805539 24/01/2008 14:06:54 > 805539 24/01/2008 14:08:09 > 961254 24/01/2008 13:42:32 > 961254 24/01/2008 13:44:23 > 961254 24/01/2008 13:44:59 > 961254 24/01/2008 13:45:13 > 961254 24/01/2008 13:46:10 > > I would like to have: > > Id Datetime > ------- ------------------- > 1412554 24/01/2008 14:09:31 > 1519040 24/01/2008 14:04:29 > 736856 24/01/2008 14:08:17 > 805539 24/01/2008 14:08:09 > 961254 24/01/2008 13:46:10 > > Many thanks! > > Cheers, > > Garry > > --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
