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
MySQL doesn't support TOP, however, there's a LIMIT syntax for MySQL that
roughly does the same thing:
http://www.mysql.com/doc/en/SELECT.html for a brief explanation.
In your example what you are looking for is:
SELECT DateCreatedField
FROM my_table
ORDER BY DateCreatedField DESC
LIMIT 10;