/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

2 votes312 views2 answers
Python escape string for sql
SQL
0 vote283 views1 answer
Manage Database in MySQL
SQL
5 votes311 views1 answer
Mysql count lines
SQL
0 vote287 views1 answer
View t-sql mail configuration
SQL
10 votes234 views2 answers
Sql where clause multiple values
SQL
0 vote281 views1 answer
Select sql in descending order
SQL
1 vote274 views1 answer
Tsql get beginning of year
SQL
12 votes251 views1 answer
Env var for setting password for root user mysql docker hub
SQL
10 votes277 views2 answers
SQL rounding numbers
SQL
0 vote272 views1 answer
Str_to_date sql server
SQL