0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for members of the workforce navigating the professional setting

SELECT   TOP 10 q.Id, q.Title, q.CreationDate as QuestionDate, q.Tags, q.AnswerCount, 
                a.CreationDate as AnswerDate
FROM     Posts q
JOIN     Posts a
ON       a.Id =
         (
         SELECT  TOP 1 ap.Id 
         FROM    Posts ap
         WHERE   ap.ParentId = q.Id
         ORDER BY ap.CreationDate
         )
WHERE q.CreationDate > Convert(datetime, '2016-12-31' )

fork query

edited dec 8 19

created dec 8 19 anonymous