MS-SQL Server - How to Fetch MAX Date Records from a Table

How to Fetch MAX Date Records from a Table

SELECT p1.productid,
       p1.price,
       p1.lastupdate
FROM   product p1
       INNER JOIN (SELECT productid,
                          Max(lastupdate) max_date
                   FROM   product
                   GROUP  BY productid) p2
               ON p1.productid = p2.productid
                  AND p1.lastupdate = p2.max_date;