SELECT COUNT(*), COUNT(DISTINCT(q.Id)) FROM Posts AS q IN...

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 COUNT(*), COUNT(DISTINCT(q.Id))
  FROM Posts AS q
  INNER JOIN Posts AS a
    ON q.Id = a.ParentId
   AND q.OwnerUserId = a.OwnerUserId
  WHERE q.OwnerUserId = ##UserId:int##

Enter Parameters

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