When the number of rows in a select query are a lot, we can limit
them by the LIMIT
statement.
-- only return 3 item
SELECT * FROM users LIMIT 3;
-- +----+---------------------+------------+-----------+--------------------------------+----------------+--------+
-- | id | datetime_joined | first_name | last_name | email | city | active |
-- |----+---------------------+------------+-----------+--------------------------------+----------------+--------|
-- | 1 | 2023-08-18 21:44:13 | Carmen | Malone | [email protected] | East Jeanmouth | True |
-- | 2 | 2023-07-27 04:31:11 | Stephanie | Wallace | [email protected] | West Misty | True |
-- | 3 | 2023-01-30 08:00:52 | Brandon | Jenkins | [email protected] | Pinedamouth | True |
-- +----+---------------------+------------+-----------+--------------------------------+----------------+--------+