How do I query in SQL for getting the latest record date for each user ?
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.