I have a table record like below:-
my_table
id | rating | description
1 | 0.0 | bed
2 | 1.0 | good
3 | 0.0 | bed
4 | 1.0 | good
5 | 0.0 | bed
6 | 0.0 | bed
7 | 0.0 | bed
我将这个表格按照评分排序,并得到了以下结果。(查询语句:SELECT * FROM my_table ORDER BY rating DESC)
结果表格:
id | rating | description
2 | 1.0 | good
4 | 1.0 | good
1 | 0.0 | bed
==> 3 | 0.0 | bed
5 | 0.0 | bed
6 | 0.0 | bed
7 | 0.0 | bed
现在我想要id为3的先前记录。
期望结果
id | rating | description
1 | 0.0 | bed
我该如何在单个MySQL查询中实现它?请帮助我。
select * from my_table where rating = {你想要的} order by id limit 1
。 - ZZ-bb