LIMIT « Select Query « MySQL Tutorial






  1. MySQL Tutorial
  2. Select Query
  3. LIMIT
2.6.LIMIT
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