0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for information security professionals

select  CAST(CreationDate as DATE), count(*) as count
from Users
WHERE CAST(CreationDate as DATE) > '2009-12-31'
group by CAST(CreationDate as DATE)
ORDER BY CAST(CreationDate as DATE) desc;

fork query

edited feb 20

created feb 20 anonymous