/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 vote341 views2 answers
Plpgsql
SQL
18 votes267 views2 answers
How to get all the tables displayed in oracle
SQL
0 vote322 views1 answer
Regex any word except sql
SQL
7 votes325 views3 answers
Add primary key to database sql
SQL
0 vote316 views1 answer
Postgres enumerated type
SQL
0 vote396 views1 answer
Mysql get nested records
SQL
5 votes344 views4 answers
Traduction
SQL
1 vote328 views1 answer
Cannot load driver class: com.mysql.cj.jdbc.Driver
SQL
0 vote264 views1 answer
Update sql join multiple tables
SQL
2 votes291 views1 answer
Mysql list users on ubuntu
SQL