What is the role of a limit in a MySQL query?
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