How do I query in SQL for getting the latest record date for each user ?

504 Asked by CaroleThom in SQL Server , Asked on Mar 6, 2021

I have a SQL table that is a collection entry as to when a user was logged on.

username, date, value

--------------------------

brad, 1/2/2010, 1.1

fred, 1/3/2010, 1.0

bob, 8/4/2009, 1.5

brad, 2/2/2010, 1.2

fred, 12/2/2009, 1.3 etc..

How do I trigger a query that would give me the latest date for each user? and, I needed to have a value that goes along with the sql most recent date.

Answered by Carole Thom

How do I query in SQL for getting the latest record date for each user ?

Your Answer