Hi there. Struggling with the limits of SOQL .... if looking for a way to retrieve the most recent case for all accounts. In SQL such would be very simple ...

SELECT ID FROM Case U1
WHERE CreatedDate = (SELECT MAX(CreatedDate) FROM Case WHERE AccountID= U1.AccountID)

But SOQL does not allow me to due to the bind variable. Would anyone be able to support ?