Const
MySQL grammar facts. LIMIT [offset,] n / LIMIT n OFFSET m and no FETCH FIRST (https://dev.mysql.com/doc/refman/8.4/en/select.html); WITH RECURSIVE (https://dev.mysql.com/doc/refman/8.4/en/with.html); EXCEPT and INTERSECT from 8.0.31 (https://dev.mysql.com/doc/refman/8.0/en/except.html); LATERAL from 8.0.14 (https://dev.mysql.com/doc/refman/8.0/en/lateral-derived-tables.html). ORDER BY in a derived table is accepted, though the optimizer may ignore it (https://dev.mysql.com/doc/refman/8.4/en/derived-table-optimization.html).
LIMIT [offset,] n
LIMIT n OFFSET m
WITH RECURSIVE
MySQL grammar facts.
LIMIT [offset,] n/LIMIT n OFFSET mand no FETCH FIRST (https://dev.mysql.com/doc/refman/8.4/en/select.html);WITH RECURSIVE(https://dev.mysql.com/doc/refman/8.4/en/with.html); EXCEPT and INTERSECT from 8.0.31 (https://dev.mysql.com/doc/refman/8.0/en/except.html); LATERAL from 8.0.14 (https://dev.mysql.com/doc/refman/8.0/en/lateral-derived-tables.html). ORDER BY in a derived table is accepted, though the optimizer may ignore it (https://dev.mysql.com/doc/refman/8.4/en/derived-table-optimization.html).