Subset of Duplicate Questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Signal Processing Meta

Q&A about the site for practitioners of the art and science of signal, image and video processing

/*SELECT COUNT(*) FROM PendingFlags
WHERE DuplicateOfQuestionId IN (
  SELECT DuplicateOfQuestionId FROM PendingFlags
  WHERE DuplicateOfQuestionId != 0
  AND CreationDate > '2021-01-01')*/
  
  SELECT SUM(COUNT(Id)) OVER() FROM PendingFlags
WHERE DuplicateOfQuestionId > 0
GROUP BY DuplicateOfQuestionId
HAVING COUNT(Id) > 1
ORDER BY COUNT(Id) DESC

Enter Parameters

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