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!