Question

What is the use of LIMIT clause with SELECT query?

Answer 1

LIMIT clause is used with SELECT statement when we want a limited number of fetched records.

Syntax:

SELECT column1, column2, columnN     

FROM table_name    

LIMIT [no of rows]