在Microsoft Access中从...选择顶部(除10外的所有) [英] Select Top (all but 10) from ... in Microsoft Access

问题描述

说我有一个查询

SELECT TOP 10 ... FROM ... ORDER BY ...

在Access中(嗯，真的是Jet).问题是:如何获取所有其他行...除前十名之外的所有内容?

in Access (well, really Jet). The question is: how can I get all the other rows... everything except the top 10?

推荐答案

你不能做类似的事情

SELECT ... FROM ...
WHERE PK NOT IN (SELECT TOP 10 PK FROM ...)
ORDER BY ...

它可能没有那么高效，但这是我可以想到的唯一方法. AFAIK SQL中没有"BOTTOM"子句:)

it might not be that efficient but that's the only way off the top of my head I can think to do something like that. AFAIK there's no "BOTTOM" clause in SQL :)

这篇关于在Microsoft Access中从...选择顶部(除10外的所有)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！