sql limit offset code example

Example 1: limit offset

SELECT * FROM artists LIMIT 5 OFFSET 2;

Example 2: mysql limit

SELECT * FROM `members` LIMIT 1, 2;
or
 $sql = "SELECT * FROM Orders LIMIT 30";

Example 3: sql limit with offset

LIMIT row_count OFFSET offset;

Example 4: limit offset

SELECT * FROM artists LIMIT 5 OFFSET [Number of rows to skip];