sql - Return a row with the max date

Question

This question already has answers here: question from:https://stackoverflow.com/questions/65903938/return-a-row-with-the-max-date

Answer 1

You can use ORDER BY and TOP:

select top (1) a.*
from [AX2012_PROD].[dbo].[AAALTLCHANGEREQUESTARCHIVE] a
where a.AAAREFNUMVALUE = '17743965' and a.AAASENTTOLTL = '1'
order by CREATEDDATETIME desc;