MySQL 3.23.41 on Solaris
Is it possible to select only the latest entries from a table? For instance I have a table of datasets that get loaded each day. I want to find the latest date that each dataset was loaded. I thought maybe a join against itself might be the answer, but this doesn't seem to work :) SELECT B.* from lkup_info AS A, lkup_info AS B WHERE A.did = B.did AND MAX(A.date) = B.date GROUP BY A.did; But that is basically what I want... Is this possible, or do I need to maintain a table for latest updates? -- ___ __ __ __ _ _ ____ _ _ ____ ____ / __)( )( ) /__\( \/ )( ___) ( \( )( ___)(_ _) \__ \ )(__)( /(__)\\ / )__) ) ( )__) )( (___/(______)(__)(__)\/ (____)()(_)\_)(____) (__) "It's the same thing" said Pooh. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
