如果您这样做：
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)
602392714
清零编程群