Retrieve latest Rows in table

I want to get last updated status in this table..

what I want :

WHAT I TRIED

SELECT
  u1.NIC,
  u1.Status,
  u1.Remarks,
  u1.ADT
FROM callsc2 u1
  LEFT OUTER JOIN callsc2 u2
    ON u1.NIC = u2.NIC
    AND u1.ADT > u2.ADT

>Solution :

This can be done by joining your table with a dataset containing max ADT per status :

SELECT u.*
FROM callsc2 u
INNER JOIN (
  SELECT NIC, MAX(ADT) AS MAX_ADT
  FROM callsc2 
  GROUP BY NIC
) AS s on s.NIC = u.NIC AND s.MAX_ADT = u.ADT