SELECT TOP 30 CreationDate, MAX(Count(*)) OVER(PARTITION ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Computational Science Meta

Q&A about the site for scientists using computers to solve scientific problems

SELECT TOP 30
  CreationDate,
  MAX(Count(*)) OVER(PARTITION BY CreationDate) as [ApproveEditSuggestion Votes]
FROM Votes
WHERE VoteTypeId = 16
GROUP BY CreationDate
ORDER BY CreationDate DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results