/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

5 votes113 views3 answers
Select tables from mysql database
SQL
2 votes100 views1 answer
Wait delay in sql server
SQL
4 votes109 views4 answers
Oracle tablespace tables list
SQL
0 vote221 views1 answer
Python get backup of sql
SQL
0 vote110 views1 answer
Change date in pivot table to month in sql server
SQL
4 votes141 views1 answer
How to drop a database in sql server when it is in use
SQL
0 vote147 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL
7 votes204 views2 answers
Sql empty table
SQL
0 vote107 views1 answer
An error occurred while installing mysql2 (0.5.3)
SQL
0 vote164 views1 answer
Connect google bigquery connect using sqirrel
SQL