use limit in mysql command code example

Example: mysql limit

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