仅获取倒数第二条记录-mysql-query [英] Get only second last record - mysql-query

问题描述

我有一个如下表记录:-

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等级DESC)

Now I shorted this table by rating and I got following result. (Query : 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记录.

Now I want previous record of id = 3.

预期结果

        id | rating      | description

         1 |         0.0 | bed

我如何实现它.单个mysql查询内? 请帮助我.

How can I achieve it. within single mysql query? Please help me.

推荐答案

使用此:

SELECT * FROM my_table ORDER BY rating DESC LIMIT 2,1

这篇关于仅获取倒数第二条记录-mysql-query的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！