SQL Query to select record with Maximum Date in SQL Server

Hi sthsyed,

Refer the below sample test query.

SQL

DECLARE @VS_Transaction AS TABLE(Vin VARCHAR(50),Entry_Date DATETIME,Status CHAR(15))
INSERT INTO @VS_Transaction VALUES('3KPA351A1JE072740','2018-01-23 08:12:27.560','Delete')
INSERT INTO @VS_Transaction VALUES('3KPA351A1JE072740','2018-01-22 15:32:01.000','RQT')
INSERT INTO @VS_Transaction VALUES('3KPA351A1JE072740','2018-01-25 15:32:01.000','RQT')

Select TOP 1 Vin,Entry_Date,Status
from @VS_Transaction 
where Status='RQT' or Status='Delete'
group by Vin,Entry_Date,Status 
order by Entry_Date desc

Output