I have the following query to get me the values corresponding with the latest date:
SELECT MAX(RowAddedDate), X, Y FROM dbo.MyTable GROUP BY X, Y
This is fine, but I need to get the ID of each row in this query. If I add the ID though, I get everything as the ID needs to be in the
How do I solve this?