0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for Tridion developers and administrators

-- Enter Query Title
-- Enter Query Description
--Select MONTH(CreationDate) MONTH, Count(CreationDate) count_records from Users where YEAR (CreationDate) >= '2010' GROUP BY MONTH (CreationDate) q2
   SELECT YEAR(CreationDate) AS y,
           MONTH(CreationDate) AS m,
           COUNT(*) AS tally,
           COUNT(*) tally
    FROM   Users
    WHERE  YEAR(CreationDate) >= '2010'       
    GROUP BY
           YEAR(CreationDate),
           MONTH(CreationDate);

fork query

edited jan 26

created jan 26 anonymous