1. Computing

Limit - MySQL Command


Definition: Limit is used to limit your MySQL query results to those that fall within a specified range. You can use it to show the first X number of results, or to show a range from X - Y results. It is phrased as Limit X, Y and included at the end of your query. X is the starting point (remember the first record is 0) and Y is the duration (how many records to display).
Also Known As: Range Results
 SELECT * FROM `your_table` LIMIT 0, 10 
This will display the first 10 results from the database.
 SELECT * FROM `your_table` LIMIT 5, 5 
This will show records 6, 7, 8, 9, and 10
  1. About.com
  2. Computing
  3. PHP / MySQL
  4. MySQL Commands
  5. SQL Limit - MySQL Limit - SQL Limit Results

©2014 About.com. All rights reserved.