select * from Table order by ModifyDate desc
Will give you data by descending order of modification.
you can choose to have
select top 1 * from Table order by ModifyDate desc
to get latest modification date.
Other way is to apply Ranking function
select *,Row_Number() Over (order by ModifyDatedesc ) As LatestRecord from Table order by ModifyDate desc
and then you can filter LatestRecord column on 1 which will hold latest date.
You can also check this
SELECT * FROM TABLENAME ORDER BY PRIMARYCOLUMNNAME DESC
FETCH FIRST 1 ROWS ONLY ;
BUT THIS OPTION IS VALID ONLY IF THERE IS A PRIMARY KEY
COLUMN,OTHERWISE IT WONT WORK