SELECT TOP 30 CreationDate, COUNT(*) as theCount, MAX(Cou...

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,
  COUNT(*) as theCount,
  MAX(Count(*)) OVER(PARTITION BY CreationDate) as MaxPerGroup
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