Skip to main content

Return to Answer

Post Timeline

code formatting
Source Link
DarthJDG
DarthJDG
  • 16.6k
  • 11
  • 53
  • 56

This should be as simple as:

SELECT UserId, Value FROM Users u WHERE Date = (SELECT MAX(Date) FROM Users WHERE UserID = u.UserID)

SELECT UserId, Value
FROM Users u
WHERE Date = (SELECT MAX(Date) FROM Users WHERE UserID = u.UserID)

This should be as simple as:

SELECT UserId, Value FROM Users u WHERE Date = (SELECT MAX(Date) FROM Users WHERE UserID = u.UserID)

This should be as simple as:

SELECT UserId, Value
FROM Users u
WHERE Date = (SELECT MAX(Date) FROM Users WHERE UserID = u.UserID)
Source Link
Valerion
Valerion
  • 831
  • 8
  • 15

This should be as simple as:

SELECT UserId, Value FROM Users u WHERE Date = (SELECT MAX(Date) FROM Users WHERE UserID = u.UserID)