MariaDB Interview Question:

Tell me how can you retrieve limited number of records from a table?

Submitted by: Muhammad

LIMIT clause is used with SELECT statement to select a limited number of records from a table. It facilitates you to retrieve records according to your use.

Syntax:
SELECT expressions
FROM tables
[WHERE conditions]
[ORDER BY expression [ ASC | DESC ]]
LIMIT row_count;
Submitted by: Muhammad