Solved

Help with SQL

Posted on 2013-01-02

Microsoft SQL Server

1 solution

162 Views

Last Modified: 2013-01-02

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

Comment

Question by:JElster

[X]

Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

Help others & share knowledge
Earn cash & points
Learn & ask questions

Join The Community

1 Comment

LVL 22

Accepted Solution

by:Steve Wales

Steve Wales earned 320 total points

ID: 387366422013-01-02

select [user], max(datetime_login)
from login_history
group by [user]

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Cloud+Hadoop – A Boom To Cloud Market; Know What AWS & Azure Has To Contribute

Article by: Shakshi

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.

5 Lessons the Delta Outage Should Teach Us About Datacenter Security and Disaster Prevention

Article by: Concerto Cloud

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…