SQL Query to Get TOP N records from MYSQL
By Super Man
How you can get top N records from mysql
select * from table1 limit 10
it will returns only 10 records from the table.
if you want to specified order then you can also specifed order by attribute.
select * from customers order by registrationdate desc limit 10
it will gives you last 10 registered customer detail.
SQL Query to Get TOP N records from MYSQL (862 Views)