MySQL Top Rows
Selecting the top number of rows that you specify is actually a bit harder on MySQL than it is on MSSQL. To select the top 10 rows in one of your tables you have to use the following query style :
SELECT * FROM {table} ORDER BY {row} asc LIMIT 10
This will select the top 10 rows from your table. If you would like to select the bottom 10 rows, simply replace asc with desc.
And of course, if you want more or less than 10, you can replace that number as well.
