I want to select say 100 of 1,000 records and get the highest value for "id" in that query, however the MAX command always gives me the MAX for the whole table, not just my query.
Here's my expression: SELECT MAX(id) FROM table WHERE DATE = '20020509' LIMIT 100 No matter what, I will always get the max for the column for the whole table....adding and removing the "LIMIT" command changes absolutely nothing... Thanks to anyone that might be able to help me... Frustrated, Andrew --------------------------------------------------------------------- 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
