MYSQL LIMIT 10 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;
SELECT
customerNumber,
customerName,
creditLimit
FROM
customers
ORDER BY creditLimit DESC
LIMIT 10;
SELECT * FROM `members` LIMIT 1, 2;