MariaDB Select Limit

MatiaDB SELECT Limit

In MariaDB database, SELECT statement is used with LIMIT clause to retrieve one or more records from a table.

Syntax:

 SELECT expressions FROM tables [WHERE conditions] [ORDER BY expression [ ASC | DESC ]] LIMIT row_count;  

Example1:

Retrieve records in descending order:

Let’s use SELECT statement with LIMIT clause in “Students” table. The result is displayed in descending order and LIMIT is 4.

 SELECT student_id, student_name, student_address FROM Students WHERE student_id <= 7 ORDER BY student_id DESC LIMIT 4; 

Output:

Mariadb Select limit 1

Example2:

Retrieve records in ascending order:

 SELECT student_id, student_name, student_address FROM Students WHERE student_id <= 7 ORDER BY student_id ASC LIMIT 4; 

Output:

Mariadb Select limit 2