/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 vote234 views2 answers
Check if sql temp table exists
SQL
0 vote225 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
0 vote207 views1 answer
Postgres float to int
SQL
0 vote216 views1 answer
How to get data between a last week in mysql
SQL
1 vote232 views1 answer
Add many column to sap iq table
SQL
22 votes216 views4 answers
Tsql rename table
SQL
0 vote234 views1 answer
Materialized view redshift
SQL
10 votes202 views1 answer
How to import database in mysql by cmd
SQL
0 vote215 views1 answer
Mysql config slave
SQL
-1 vote227 views4 answers
Restart mysql server ubuntu
SQL