Q&A for speakers of other languages learning English
SELECT c.Id, c.Text, c.CreationDate FROM Comments c INNER JOIN ( SELECT Id, MAX(CreationDate) AS MaxCreationDate FROM Comments GROUP BY Id ) mc ON c.Id = mc.Id AND c.CreationDate = mc.MaxCreationDate where c.id = 40419824