SELECT a.*, u.* FROM Posts as a JOIN Posts as q on q.Id =...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT a.*, u.*
--SELECT count(*)
FROM Posts as a
JOIN Posts as q on q.Id = a.ParentId
JOIN Users as u on u.Id = a.OwnerUserId
WHERE q.CreationDate > '2020-9-20 00:00:00'
AND q.CreationDate < '2020-10-01 00:00:00'

Enter Parameters

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