0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT *, COUNT(*)
FROM (
  SELECT 
  cast (DATEPART(YYYY, Users.CreationDate) as int)[YEAR]
  FROM Users
) AS t
where [YEAR] < year(getdate())
GROUP BY [YEAR]
ORDER BY [YEAR] ASC

fork query

edited jun 1 Jon "not doe" Ericson

created apr 7 16 anonymous