Hi, In a previous job I had the (mis)fortune to develop software exclusively on DB2. While doing so I would often use FETCH to examine a certain number of records. Example:
SELECT * from table FETCH FIRST 10 ROWS ONLY. When I use this particular syntax in any mysql interface (I've used 2) I get syntax error statements. Now either I have forgotten the exact syntax (unlikely, but possible) or mysql doesn't support this. Assuming the latter, is there an alternative method to acheive my desired result or do I have the syntax wrong? Any help would be greatly appreciated. Sean --------------------------------------------------------------------- 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