SELECT c.Id, c.Text, c.CreationDate FROM Comments c INNER...

0

Please login or register to vote for this query.

(click on this box to dismiss)

English Language Learners

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

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results