/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

4 votes160 views1 answer
Oracle show errors
SQL
0 vote151 views4 answers
Sql year
SQL
1 vote151 views1 answer
How to update date add hours in postgresql
SQL
0 vote203 views1 answer
Migrations.RunSQL
SQL
0 vote230 views1 answer
How to get table current identity value in sql server
SQL
0 vote204 views1 answer
Mysql remove last character
SQL
3 votes156 views3 answers
Postgresql random number
SQL
1 vote150 views1 answer
Hexadec to sql REDSHIFT
SQL
1 vote170 views2 answers
How to install sql server management studio in ubuntu 18.04
SQL
0 vote170 views1 answer
PSQL qith variables
SQL