/SQL/Get records in sql according to month name and count

Get records in sql according to month name and count

SELECT EXTRACT(month FROM dateofappointment) "Month", count(*)
FROM appointment
WHERE EXTRACT(YEAR FROM dateofappointment) = '2014'
GROUP BY EXTRACT(month FROM dateofappointment)
ORDER BY EXTRACT(month FROM dateofappointment);

Source: stackoverflow.com

Similar codes

0 vote250 views1 answer
Sql find leading space
SQL
32 votes302 views6 answers
Rename column mysql
SQL
7 votes252 views1 answer
Connect mysql docker
SQL
6 votes286 views2 answers
Foreign key sqlite3 python
SQL
0 vote281 views1 answer
SQL check if record exist
SQL
0 vote266 views1 answer
Mariadb date equals to current_date plus days
SQL
0 vote277 views1 answer
Date datatype in livesql
SQL
2 votes253 views2 answers
Mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
SQL
0 vote247 views2 answers
How to find sql server agent jobs related to a database
SQL
13 votes269 views1 answer
Fetch first 5 rows in oracle sql developer
SQL