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

Tolal:0 Click:

Show All Comments

Did not find what you were looking for leave your name and message. We will revert within 24 hours
Name:
eMail:
Comment / Feedback: