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

543    Asked by AditiIshii in SQL Server , Asked on Mar 20, 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 Aditi Ishii

Your Answer

Interviews

Parent Categories