# SELECT LIMIT in MariaDB

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


Please Share