Javatpoint Logo
Javatpoint Logo

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




Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA