/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

-1 vote330 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL
1 vote328 views2 answers
How to drop a unique constraint in sql
SQL
1 vote370 views1 answer
Primary key with prefix sql
SQL
1 vote349 views1 answer
How to change owner in postgres
SQL
3 votes335 views2 answers
Having in mysql
SQL
0 vote340 views1 answer
Oracle synonym procedure dblink
SQL
0 vote437 views1 answer
Oracle simple quote
SQL
0 vote348 views1 answer
Create date sql
SQL
1 vote323 views1 answer
Oracle current sequence value
SQL
0 vote373 views1 answer
How to join result table in mysql
SQL