max date records

;WITH cte AS
(
        SELECT id, address1, [date],
                ROW_NUMBER() OVER (PARTITION BY id ORDER BY [date] DESC) AS RN
        FROM
                YourTable
)
SELECT id, address1, [date] FROM cte WHERE RN = 1;