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;
Syntax:
SELECT expressions
FROM tables
[WHERE conditions]
[ORDER BY expression [ ASC | DESC ]]
LIMIT row_count;
Download MariaDB Interview Questions And Answers
PDF
Previous Question | Next Question |
Please explain what are the main features of MariaDB? | Tell me what are the different types of clauses used in MariaDB? |