MS Access查询-选择最近日期 [英] MS Access query - select most recent date

问题描述

我正在设计一个查询，该查询从多个不同的表中获取数据.在MS Access 2010中，我将如何创建查询列之一，以便它为表中的每个用户返回一系列日期中的最近日期:

I have a query I'm designing which grabs data from multiple different tables. In MS Access 2010, how would I create one of the query columns so that it returns the most recent date out of a series of dates, for each user in the table:

表中的样本数据:

userid: | appointment:
000001  | 05/10/2009
000001  | 05/10/2010
000001  | 05/11/2010
000002  | 05/12/2009
000002  | 30/12/2010

字段查询的预期输出:

userid:  | appointment:
000001   | 05/11/2010
000002   | 30/12/2010

推荐答案

SELECT userid, Max(appointment) AS most_recent
FROM YourTable
GROUP BY userid;

这篇关于MS Access查询-选择最近日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！