MySQL选择两个具有重复条件的最小id

Question

所以我有一个像这样的 table 房间

+---------+-------------+
| room_id | status      |
+---------+-------------+
| 1       | unavailable |
| 2       | available   |
| 3       | unavailable |
| 4       | available   |
| 5       | available   |
+---------+-------------+

如果我用

SELECT * FROM room WHERE status='available'

输出当然会是

+---------+-----------+
| room_id | status    |
+---------+-----------+
| 2       | available |
| 4       | available |
| 5       | available |
+---------+-----------+

但是我只想像这样输出两个最小的id

+---------+-----------+
| room_id | status    |
+---------+-----------+
| 2       | available |
| 4       | available |
+---------+-----------+

你们能帮我解决这个问题吗？谢谢

Answer 1

您可以在下面尝试 - 使用 order by 和 limit

SELECT * FROM room WHERE status='available'
order by room_id asc
limit 2