It is used with the SELECT statement to restrict the number of rows in the result set. Limit accepts one or two arguments which are offset and count.

The syntax of limit is a

SELECT name, salary FROM employee LIMIT 1, 2

BY Best Interview Question ON 26 Jan 2019