how to add limit mysql code example

Example 1: mysql limit results to 10

SELECT 
    customerNumber, 
    customerName, 
    creditLimit
FROM
    customers
ORDER BY creditLimit DESC
LIMIT 10;

Example 2: mysql limit

SELECT * FROM `members` LIMIT 1, 2;