How to select last entry per ID in SQL

Question

I have a big log table with 2 million rows give or take.

I am looking to look for the last entry for each id.

The 3 columns of importance are

Userid
Actiontype
Actiontime
Text2

Some userids show up thousands of times some just show up once. I need the most recent of each userid. I tried to use 'Group By' but it wont work because text2 is different for each entry which is really the data I need. So it needs to be ordered by actiontime, actiontype needs to be 103. I am really at a loss how to do this.

Any help would be appreciated.

http://dba.stackexchange.com/questions/86415/retrieving-n-rows-per-group — Aaron Bertrand, May 30 '16 at 20:26
well the 2 million rows are only with that certain actiontype otherwise it has 50 million. — Psycnosis, May 30 '16 at 20:35

John Cappelletti · Accepted Answer · 2022-09-07T14:19:24.643

2

Select B.*
 From  (
        Select UserID,ActionTime=max(ActionTime) 
         From  SomeTable
         Group By UserID
       ) A
 Join SomeTable B on A.UserID=B.UserID and A.ActionTime=B.ActionTime

edited Sep 07 '22 at 14:19

answered May 30 '16 at 20:28

John Cappelletti

79,615
7
44
66

This did the trick, thanks a ton – Psycnosis May 30 '16 at 20:42

How to select last entry per ID in SQL

1 Answers1