An SQL Querry

[Puiu]

I have a table Users with the fields :

 

username varchar(50),

Birthdate Datetime

 

 

I want to select the month in which most users are born

[HJB417]

I'd think you'd want something like

 

SELECT COUNT(username) AS num_of_users, MONTH(Birthdate)

GROUP BY MONTH(Birthdate)

ORDER BY num_of_users

[PROKA]

more like

SELECT TOP 1 MONTH(Birthdate) FROM Users
GROUP BY MONTH(Birthdate)
ORDER BY COUNT(username) DESC