LIMIT « Select Query « MySQL Tutorial

2.6.1.Use the LIMIT condition to restrict the number or records returned
2.6.2.To retrieve the rest of the records in batches we can also specify a starting point before the number or rows to return
2.6.3.Limit query to start at rows 3-7
2.6.4.Random order
2.6.5.Get the Row Holding the Maximum of a Certain Column by sorting all rows descending by price and get only the first row using LIMIT clause