SELECT t1.*
FROM Product t1
INNER JOIN (
SELECT
Category, MAX(Price) Max_Price
FROM Product
GROUP BY Category
) t2 ON t1.Category = t2.Category AND
t1.Price = t2.Ma_Price;