如何为每个用户Ms acess选择最后一条记录 [英] how to select last record for each user Ms acess

问题描述

各个团体

如何为每个用户选择最后一条记录例如2013年我有数据如

hi every body
how to select last record for each user Ms acess 2013 for example i have data like

1  : 20    : 1/4/2015<br />
1 : 25     : 10/4/2015<br />
1  : 30    :  15/4/2015<br />
2  : 10  :  1/5/2015<br />
2  :15     :5/5/2015<br />
2  :20    :  20/5/2015<br />
3  :5     :1/6/2015<br />
3  :10    : 10/5/2015

我怎样才能为每个用户获得最后一行

how can i get last row for each user as a result

1  : 30    :  15/4/2015<br />
2  :20    :  20/5/2015<br />
3  :10    : 10/5/2015

i尝试top，max但是如何实现它是无用的

i try top, max but it was useless how it can be achieved

推荐答案

请在下面找到MSSQL的逻辑。

根据您的要求更改MS - Access。

将您的清单视为

Id：UserId：ModifiedDate

Please find the logic for MSSQL below.
Change it in for MS - Access as per your requirement.
Considering your list as
"Id : UserId : ModifiedDate"

;with cteRowNumber as (
    select * , row_number() over(partition by Id order by ModifiedDate desc) as RowNum
        from YourTable
)
select *
    from cteRowNumber
    where RowNum = 1

这篇关于如何为每个用户Ms acess选择最后一条记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！