0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those using, extending or developing Emacs

SELECT TOP 100 q.Id AS [Question ID], q.Title AS Question, a.Body AS Answer
FROM Posts q
JOIN Posts a ON q.Id = a.ParentId
WHERE q.PostTypeId = 1
ORDER BY q.CreationDate DESC
FOR JSON AUTO

fork query

edited apr 2

created apr 2 anonymous