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
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