Hi, I am trying to select the first 10 rows of a table by the date the record was created. I have a date field in the table and I tried using the TOP syntax of SELECT, but I keep getting syntax error.
SELECT TOP 10 DateCreatedField FROM my_table ORDER BY DateCreatedField DESCENDING Does MySQL not support TOP? If it does, can somebody tell me what is wrong with that syntax? If it doesn't, can someone please tell how I can do it without getting ALL records and extracting the first 10 programmatically? Thanks, Dale Hans -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
