This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.
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
Asked:
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Featured Post
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
from login_history
group by [user]