How to use LIMIT in MySql

limi

limit   is very common word use to assign some range , similarly use in mysql .

Its very basic concept to understand, we use limit to restrict data in some range during retrival from data base, For example you have millions of record in database and you want to get just few of them then you can pass your rang to query which is known as limit

below is the example how to use it in query 

Also Known As: Range Results

Examples:

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