SQL Query to Get TOP N records from MYSQL

How you can get top N records from mysql

SQL query:


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.