/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

6 votes124 views2 answers
Oracle undotbs usage
SQL
10 votes130 views4 answers
Drop primary key
SQL
0 vote166 views1 answer
SQL Server Enterprise
SQL
0 vote144 views1 answer
Interview experience as a call?
SQL
0 vote128 views1 answer
Postgres data location
SQL
1 vote129 views4 answers
Psql check tables command
SQL
3 votes140 views1 answer
Sql cast to integer
SQL
7 votes129 views6 answers
Nth highest salary in sql
SQL
12 votes144 views10 answers
Google
SQL
0 vote132 views1 answer
How to increase the width of the screen in oracle
SQL