/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

58 votes318 views4 answers
Mysql drop column
SQL
-1 vote168 views2 answers
REMOVE DATE FROM DATE TIME SQL SERVER
SQL
0 vote164 views1 answer
Object Information
SQL
0 vote177 views1 answer
Stored function in sql
SQL
0 vote185 views1 answer
How to map sql column to custom names
SQL
0 vote171 views1 answer
What is mysql_pconnect
SQL
0 vote189 views1 answer
No query unable to fetch row sqlite
SQL
-1 vote189 views3 answers
How to restart mysql in linux
SQL
1 vote176 views1 answer
Mysql show queries running
SQL
65 votes291 views6 answers
Sql add column to table
SQL