I am using the following query, but am still getting dupes.
Select va.LoanNumber,Max(va.CreateDate),va.LoanStatus,va.Source,va.LoanOfficerName From VehicleApplication va Where va.AppReceiveDate Between '10/01/2017' AND '12/31/2018' AND va.loanStatus In ('APP','AD', 'DEC', 'OFF', 'AA') Group By va.LoanNumber, va.LoanStatus,va.Source,va.LoanOfficerName Order By va.LoanNumber
select va.LoanNumber,va.CreateDate,va.LoanStatus,va.Source,va.LoanOfficerName
from (
Select *, row_number() over(partition by LoadNumber order by CreateDate desc) as row_num
From VehicleApplication
) as va
where va.row_num = 1
Order By va.LoanNumber