Hi.
I have a table of login data. Need to find the most recent login by user - return single record for each user - need group by user and most recent login datetime
The data looks this
USER DATETIME LOGIN
JOHN 1/2/2013 1:00
GAYLE 1/2/2012 9:00
JOHN 12/31/2012 12:00
GAYLE 12/31/2012 10:00
BOB 1/2/2012 12:00
SHOULD RETURN
GAYLE 1/2/2012 9:00
JOHN 1/2/2013 1:00
BOB 1/2/2012 12:00