SELECT YEAR(CreationDate) AS 'year', MONTH(CreationDate) ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

TeX - LaTeX

Q&A for users of TeX, LaTeX, ConTeXt, and related typesetting systems

SELECT YEAR(CreationDate) AS 'year', MONTH(CreationDate) AS 'month',PostTypeId,
  COUNT(Id) AS cnt
FROM Posts
GROUP BY YEAR(CreationDate), MONTH(CreationDate), PostTypeId
ORDER BY cnt DESC;

Enter Parameters

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