MariaDB Question:
Download Questions PDF

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

Answer:

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;

Download MariaDB Interview Questions And Answers PDF

Previous QuestionNext Question
Please explain what are the main features of MariaDB?Tell me what are the different types of clauses used in MariaDB?