CODE EXAMPLE FOR SQL

ORACLE: How to get all column with GROUP by only 1 column?

SELECT t.FIRST_NAME,
       t.LAST_NAME,
       t.EMP_ID,
       t.WRIST_STATUS,
       t.LFOOT_STATUS,
       t.DATE
FROM
(
    SELECT FIRST_NAME, LAST_NAME, EMP_ID, WRIST_STATUS, LFOOT_STATUS, DATE,
           ROW_NUMBER() OVER (PARTITION BY EMP_ID ORDER BY DATE DESC) rn
    FROM ESD_RESULTS
) t
WHERE t.rn = 1