Selecting The Last Entry in a Log Table for each user

[cooldude832]

Title basically says it

 

LOG TABLE

 

LogID 

Date_Entered

UserID

UnderwriterID

Message

 

 

I want to get 1 row for each UserID that is the row of the max Date_Entered (or max LogID as they are the same)

[rhodesa]

SELECT UserID,MAX(Date_Entered) as MaxDate FROM LogTable GROUP BY UserID

[Barand]

try

SELECT l.LogID, l.Date_Entered, l.UserID, l.UnderwriterID, l.Message
FROM log l
INNER JOIN (
    SELECT logID, MAX(Date_Entered) as Date_Entered
    FROM log GROUP BY logID
    ) as X USING (logID, Date_Entered)