我不知道你的列的确切名称，但它应该是这样的:

SELECT userid, value
FROM users u1
WHERE date = (
    SELECT MAX(date)
    FROM users u2
    WHERE u1.userid = u2.userid
)

Select  
   UserID,  
   Value,  
   Date  
From  
   Table,  
   (  
      Select  
          UserID,  
          Max(Date) as MDate  
      From  
          Table  
      Group by  
          UserID  
    ) as subQuery  
Where  
   Table.UserID = subQuery.UserID and  
   Table.Date = subQuery.mDate  

我想这应该有用吧?

Select
T1.UserId,
(Select Top 1 T2.Value From Table T2 Where T2.UserId = T1.UserId Order By Date Desc) As 'Value'
From
Table T1
Group By
T1.UserId
Order By
T1.UserId

select   UserId,max(Date) over (partition by UserId) value from users;

检查这个链接，如果你的问题似乎类似的页面，然后我会建议你下面的查询，将给出该链接的解决方案

选择不同的sno,item_name,max(start_date) over(sno分区)，max(end_date) over(sno分区)，max(creation_date) over(sno分区)， Max (last_modified_date) over(sno分区) 从uniq_select_records 按sno,item_name asc排序;

是否会给出与该链接相关的准确结果

假设Date对于给定的UserID是唯一的，下面是一些TSQL:

SELECT 
    UserTest.UserID, UserTest.Value
FROM UserTest
INNER JOIN
(
    SELECT UserID, MAX(Date) MaxDate
    FROM UserTest
    GROUP BY UserID
) Dates
ON UserTest.UserID = Dates.UserID
AND UserTest.Date = Dates.MaxDate