SELECT MONTH(CreationDate) AS Month, YEAR(CreationDate) A...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Academia Meta

Q&A about the site for academics and those enrolled in higher education

SELECT MONTH(CreationDate) AS Month,
YEAR(CreationDate) AS Year
FROM posts
GROUP BY CreationDate
ORDER BY Year DESC, Month ASC

Enter Parameters

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