/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 vote209 views1 answer
Oracle drop chain step
SQL
0 vote406 views1 answer
Power bi connect to postgresql
SQL
0 vote230 views1 answer
Netstat -tln mysql
SQL
0 vote232 views2 answers
Sql having multiple conditions
SQL
10 votes201 views2 answers
Linux command line import mysql database
SQL
0 vote203 views1 answer
Sqlite update only if greater
SQL
0 vote194 views1 answer
Restore backup "text" postgresql command line
SQL
1 vote276 views2 answers
Copy table in sql
SQL
0 vote211 views1 answer
Sql server sleep
SQL
9 votes202 views2 answers
Get first 3 letters in sql
SQL