如果您这样做:
select *
from t
order by value desc
limit N
您将获得前N行。
如果您这样做:
select *
from t join
(select min(value) as cutoff
from (select value
from t
order by value
limit N
) tlim
) tlim
on t.value >= tlim;
或者,您可以将其表达为:
select *
from t join
(select value
from t
order by value
limit N
) tlim
on t.value = tlim.value;
从概念上讲,以下是您想要执行的操作,但在MysqL中可能不起作用:
select *
from t
where t.value >= ANY (select value from t order by value limit N)