SELECT LIMIT in MariaDB

by

MariaDB SELECT LIMIT
To fetch limited records from the tables stored in the database, the MariaDB SELECT statement is used with LIMIT clause.

Syntax: 

SELECT columns  
FROM table_name
WHERE conditions
ORDER BY expression [ ASC | DESC ] 
LIMIT row_count;

Parameters:
columns: It is used to specify the columns or calculations to be retrieved.
table_name: It is used to specify the name of the table from which you want to retrieve the records.
conditions: It is used to specify the conditions to be strictly followed for selection.
,strong>row_count: It is used to specify the maximum number of rows to display.

Example 1: Limit in Ascending Order.
Students table:

ID	NAME	AGE
1	Joy	5
2	Smiley	13
3	Happy	11

SELECT name, age  
FROM students  
WHERE  age > 10  
ORDER BY name ASC
LIMIT 1;

Output: 

ID	NAME	AGE
3	Happy	11

Example 2: Limit in Descending Order. 

ID	NAME	AGE
1	Joy	5
2	Smiley	13
3	Happy	11

SELECT name, age  
FROM students  
WHERE  age > 10  
ORDER BY name DESC
LIMIT 1;

Output: 

ID	NAME	AGE
2	Smiley	13