select top 10 year(creationdate), month(creationdate), c...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Vi and Vim

Q&A for people using the vi and Vim families of text editors

--Count the number of Users
--where the user creationdate = 12/23/2021

select top 10 year(creationdate), month(creationdate), cast(creationdate As Date)

from users a
where cast (creationdate as Date) = '12/23/2021'
order by creationdate desc

Enter Parameters

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