Q&A
Ask and answer questions to make information more available to wider audiences.
Camila Cemp
@cempcamila 19, Jul 2023 12:00 AM
retrieve limited number of records from a table
How can you retrieve limited number of records from a table?
answers 1
Answer 1
Aiden Barti
@aidenbarti 09, Aug 2023 03:06 PM
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;