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.