需要显示PER ID的前10个结果

本文介绍了需要显示PER ID的前10个结果的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述 Hello gang，我想查询从结果中选择前10个日期，这里是SQL到目前为止 Hello gang, i want a query to select the top 10 Dates from results, here is the SQL so far 展开 | 选择 | 换行 | 行号 推荐答案 我想不出一种方法可以在直截了当的SQL中完成我害怕Dan。I can''t think of a way this can be done in straightforward SQL I''m afraid Dan. @NeoPa 我很害怕，我可以创造一个临时工。本地表， 毫无疑问仍然需要一个循环， 是否可以质疑记录集？ dlookup或其他？@NeoPa I was afraid of that, mayb i could create a temp. local table, which would still need a loop no doubt, is it possible to question a recordset? dlookup or otherwise? 我有另一个想法;也许我可以查询给出最大值，每个每个工作人员每天的日期和字符串EntryID，然后从那里查询WHERE IN（）？我相信只会涉及2个查询，每个日期，甚至可能总数， 我告诉你所有人，以便在我尝试明天之前我可以阅读此内容 在此期间的任何建议，让他们来吧 欢呼4启发BYTES / NeoPA I''ve had another idea; maybe i could query to give the max, per date per staff per daymod and string the EntryID, then query WHERE IN() from that? that i believe would involve only 2 queries, per date, maybe even total, im telling you all so that i can read this, post sleep, before i try in the ''morrow any suggestions in the meantime, keep em coming cheers 4 the inspiration BYTES/NeoPA 这篇关于需要显示PER ID的前10个结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！