Home » MariaDB Select Limit

MariaDB Select Limit

by Online Tutorials Library

MatiaDB SELECT Limit

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

Syntax:

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.

Output:

Mariadb Select limit 1

Example2:

Retrieve records in ascending order:

Output:

Mariadb Select limit 2

Next TopicMariaDB Update

You may also like