mySql - Get N Top rows

In mySql to return the first N rows execute the following:

  • select * from limit N;

Besides, mySql as a very useful feature, the “offset” in conjunction with “limit” may let define any interval that you desire, for instance to return rows 10 to 20:

  • select * from limit 10 offset 10;