How do you return the a hundred rows starting from 15th?

SELECT column_name FROM table_name LIMIT 15, 100.
The first number in LIMIT is the offset, the second is the number.

How to display top 40 rows?

In MySql, top 40 rows are displayed by using this following query:

LIMIT 0,50