asked on Help with SQL
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
thx
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
thx
Microsoft SQL Server
Last Comment
Steve Wales
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.