Select multiple MAX values from Table in SQL Server Query

Here I have created Sql Script I hope this will help you out.

SQL

DECLARE  @Table AS TABLE (Id INT, CstNo int, CalledTime SMALLDATETIME)
 
INSERT INTO @Table VALUES(1,1262,N'2015-07-30 11:04:00')
INSERT INTO @Table VALUES(2,2413, N'2015-07-30 11:11:00')
INSERT INTO @Table VALUES(1,1259, N'2015-07-30 11:25:00')
INSERT INTO @Table VALUES(2,2141, N'2015-07-30 11:14:00')
INSERT INTO @Table VALUES(1,1142, N'2015-07-30 11:10:00')
 
;WITH CTE
AS
(
	SELECT * FROM @Table
),
CTE1
AS
(
	SELECT DISTINCT Id, MAX(CalledTime) AS DATE
	FROM @Table
	GROUP BY Id
)
SELECT CTE1.Id,[Date],CTE.CstNo 
FROM CTE1
JOIN CTE
ON CTE.Id = CTE1.Id 
AND CTE.CalledTime = CTE1.[DATE]
ORDER BY CTE1.Id

Screenshot