AnsweredAssumed Answered

SQL Query for last login to UMP

Question asked by brudden1 on Feb 8, 2013
Latest reply on Mar 7, 2013 by 1_Javier

I'd like to create a SQL that would query the UMPSession table, and return an output of each user in the table, but only the most-recent time they logged in, discarding any previous lgoins for that user.

 

If I do Select user_id,login from UMPSession, it gives me a complete list of each time every user logged in. 

 

If I use Order By login DESC, I would have to scroll through multiple entries for most users to find the most-recent.

 

Since the login timestamps are unique, I can't use DISTINCT, since each row, as a whole, is distinct.

 

I know this is a SQL question, but as it relates to nimsoft, I figured it may be a SQL that someone has tried before.

 

 

thanks for any assistance!

Outcomes