MySQL

Limit in MySQL
Previous Home Next

In this command we use the Limit word to get the limited output as define in the specified conditions

Syntax

SELECT *   
FROM tablename  
WHERE Clause 
LIMIT number;

The limit number define the number of rows we want to show to get the desired output

Example

SELECT *
FROM studinfo 
LIMIT 5 ;

 

Selected output required within the limit define ,whose code is given below

Example

SELECT sid,fname,mname
FROM studinfo 
LIMIT 5 ;

Suppose we have some limited input in my table and want to print the lower order , then we have to use the ORDER BY command in DESC(descending order) type

Example

SELECT *
FROM studinfo 
ORDER BY sid DESC
LIMIT 5;

Example

SELECT *
FROM studinfo 
WHERE sid >107
ORDER BY sid DESC
LIMIT 7;

In the above command we have use two condition like sid > 107 and limit and output will be shown those fullfill its both the conditions

Previous Home Next