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

Read Online MariaDB Job Interview Questions And Answers