0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for users of Linux, FreeBSD and other Un*x-like operating systems

--SELECT MAX(ID) FROM PostsWithDeleted;
--SELECT MIN(ID) FROM PostsWithDeleted;

--SELECT * FROM PostsWithDeleted WHERE ID BETWEEN 79219070 AND 79219080;
--SELECT * FROM PostsWithDeleted WHERE ID < 100;

SELECT *
FROM PostsWithDeleted
WHERE ParentId IN
(
  SELECT ID
  FROM PostsWithDeleted
  WHERE 1=1
  AND PostTypeId = 1  --only questions, not answers/comments/etc
  AND ID < 100        --artificially limit ourselves for testing purposes
  AND AnswerCount > 1 --questions whose answer count is greater than 1
)
ORDER BY ParentId, CreationDate
;

fork query

edited nov 30 anonymous

created nov 25 davidalayachew