0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for music historians, critics, and fans

WITH SortedComments AS (
      SELECT PostId, Text AS Comment,
      CreationDate,
      ROW_NUMBER() OVER (PARTITION BY PostId ORDER BY CreationDate DESC) AS RN
      FROM Comments
      WHERE PostId in (74996040,39033194)
      ) 
SELECT p.Id, sc.Comment
FROM 
Posts p
LEFT JOIN
SortedComments sc
ON p.Id = sc.PostId
WHERE ISNULL(sc.RN,0) <= 1

view current version

edited dec 2

created dec 1 Aleksejs.Zareckis