The LIMIT clause is used to fetch a limited subset of rows from a query. The clause can be used in two ways. You can either
The counting of rows (at least for the purpose of LIMIT) begins with zero, not one. For example, to grab rows 12 through 15 of a query, you would say SELECT * FROM some_table LIMIT 11, 4;.
The practical uses of LIMIT will be covered in more detail in phrase "Paging Through a Result Set" in Chapter 8, "MySQL APIs."