Limit the Number of Resulting Records
Learn how to retrieve required rows and limit them.
We'll cover the following
Sometimes, we want to return the first row that matches the select
criteria, even if more rows might match. We can do that using the limit
at the end of the select
statement.
For example, let’s suppose that we want to get the most expensive product in our catalog. This is returned with the following select
statement:
1 mysql> select * from products order by price desc limit 1;
2 +----+-----------------------------+-------+
3 | id | name | price |
4 +----+-----------------------------+-------+
5 | 1 | Game of Thrones-S01-DVD. | 50.00 |
6 +----+-----------------------------+-------+
7 1 row in set(0.00 sec)
Let’s verify it by executing it:
Get hands-on with 1200+ tech skills courses.