WITH CTE AS (
SELECT Username, thumbnailPhoto, [Display Name], Department, USERID, email, BADGENUMBER, NAME, CHECKTYPE, CHECKTIME,
       ROW_NUMBER() OVER(PARTITION BY USERID ORDER BY CHECKTIME DESC) AS rn
FROM dbo.[AD_in_Out LOG])
SELECT Username, thumbnailPhoto, [Display Name], Department, USERID, email, BADGENUMBER, NAME, CHECKTYPE, CHECKTIME
FROM CTE
WHERE rn=1;

SELECT * FROM [AD_in_Out LOG] as tLog
INNER JOIN 
(SELECT USERID, MAX(CHECKTIME) as LastTime
GROUP BY [userid]) as tREs
ON tLog.Userid = tRes.Userid
AND tLog.CHECKTIME = tREs.LastTime