Select latest date records from database table in SQL Server

Hi muhammad12,

Please refer below SQL sample Query.

SQL

CREATE TABLE #Events
(
    [Date] VARCHAR(20),
    [Event-No] VARCHAR(10)
)

INSERT INTO #Events VALUES('15-Apr-2022', 'PA-212');
INSERT INTO #Events VALUES('15-Apr-2022', 'PA-213');
INSERT INTO #Events VALUES('16-Apr-2022', 'PA-215');
INSERT INTO #Events VALUES('16-Apr-2022', 'PA-813');
INSERT INTO #Events VALUES('16-Apr-2022', 'PA-401');
INSERT INTO #Events VALUES('16-Apr-2022', 'PA-215');

SELECT DISTINCT CONVERT(VARCHAR(20),[Date], 106) [Date], [Event-No] 
FROM #Events
WHERE [Date] = (SELECT MAX(CAST([Date] AS DATETIME)) FROM #Events)

DROP TABLE #Events

Screenshot