/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

0 vote343 views1 answer
Alter check command
SQL
1 vote355 views3 answers
Connect to mysql c# connection string C#
SQL
0 vote320 views1 answer
Mysql workbench download for iinux mint 19.3
SQL
0 vote323 views2 answers
How to get last inserted id in sql server c#
SQL
3 votes332 views3 answers
Mysql order by list
SQL
0 vote343 views4 answers
What is unique key in sql
SQL
0 vote418 views1 answer
Sqlite display headers on columns
SQL
0 vote312 views1 answer
Sql count null as 0
SQL
2 votes333 views1 answer
Oracle percentage
SQL
0 vote360 views1 answer
Is not numeric sql
SQL