How to count max(users) created in a particular year using group function.

bipinskulkarni

How to count number of users created in a perticular year.
ex.i want to count total number of users created in 2007using query.

mwasif

You can use MySQL YEAR() function like below

Expand|Select|Wrap|Line Numbers

And if you want to know which year has the more registrations, use YEAR() in this fashion

Expand|Select|Wrap|Line Numbers

 SELECT COUNT(*) AS users,  YEAR(date_col) AS registration_year FROM users_table

GROUP BY registration_year

ORDER BY users DESC

re: How to count max(users) created in a particular year using group function.