/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

3 votes182 views2 answers
Order by postgresql
SQL
0 vote250 views1 answer
Mysql loop through databases and execute query
SQL
21 votes172 views1 answer
SQL cheat sheet pdf
SQL
0 vote336 views1 answer
Current month transactions in mysql
SQL
1 vote192 views1 answer
Sql group by sum with condition
SQL
0 vote165 views1 answer
Console output pl sql
SQL
0 vote173 views1 answer
How to increase the width of the screen in oracle
SQL
0 vote206 views1 answer
Sql min
SQL
15 votes160 views2 answers
Install mysql 8 ubuntu 18.04
SQL
0 vote173 views1 answer
Version_info, _mysql.version_info, _mysql.__file__ NameError: name '_mysql' is not defined
SQL