Question

这可能是一个非常基本的问题,但我根本不知道。

为了简化问题,请允许我提出一个只列一栏的表格,以便我能够横向地勾销:

1 3 11 39 41 45 52 63 66 70 72 80 81 90 92 97

As you can see, they are sorted. Now, I know there is the row with "70", and I want to query five rows before it in ascending order. That is, I want

41 45 52 63 66

我应该怎样做?

我可以质疑五行的降价,并扭转其后取得的成果,但我认为应该有更好的办法。

Answer 1

仅修改以下案文:

SELECT * FROM (
    SELECT *
    FROM SAMPLE
    WHERE index1 < 70
    ORDER BY index1 DESC
    LIMIT 0,5
)
ORDER BY index1 ASC;

Answer 2

下面是我能够提出的询问,但我不清楚这是否是你所需要的,而且其结果是命令 des。

我设立了一个表,即SAMPLE,其唯一一个栏目是:

SELECT * FROM SAMPLE WHERE index1 < 70 ORDER BY index1 DESC LIMIT 0,5;