MySQL LIMIT

MySQL Tutorial

MySQL-Home MySQL-Environment setup MySQL- Workbench MySQL-Basic syntax MySQL-Operator MySQL-Data type MySQL-Comments MySQL-Create DB MySQL-Drop DB MySQL-Select DB MySQL-Create Table MySQL-Drop table MySQL-Truncate MySQL-Primary Key MySQL-Foreign Key MySQL-Null MySQL-Increment MySQL-Having MySQL-Top MySQL-Insert Statement MySQL-Select Statement MySQL-Alter Statement MySQL-Where MySQL-And & Or MySQL-Default values MySQL-Exists MySQL-Order by MySQL-View MySQL-Update Statement MySQL-Delete Statement MySQL-Like MySQL-Sort MySQL-Limit MySQL-Min MySQL-Max MySQL-Group MySQL-In MySQL-Between MySQL-Union MySQL-Count MySQL-Average MySQL-Sum MySQL-Date & Time MySQL-Import MySQL-Export MySQL-Index MySQL-Temporary MySQL-Join MySQL-Full Join MySQL-Inner Join MySQL-Left Join MySQL-Right Join MySQL-Store Procedure MySQL-Injection MySQL-PHP connection

« Previous Next »

The SELECT statement is used to select or retrieve the data from tables.

The LIMIT clause is used to specify the number of records to return.

The LIMIT clause specifies that how many rows are returned.

If a table has a large number of data, select LIMIT statement determines that how many rows will be retrieved from the given table.


SELECT column_name(s)
FROM table_name
WHERE condition
LIMIT number;

Here, number is the max numbers you want to retrieve.

Let's put these statements into real use.

We've a table named Students in our database that contains the following records:

Now we will fetch the top 3 records from the Students table.


SELECT TOP 3 * FROM Students;

SELECT * FROM Students 
LIMIT 3;

The above SELECT statement selects Top 3 columns from the Students table.

« Previous Next »

MySQL - LIMIT