/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 votes196 views2 answers
Exec procedure pl sql
SQL
6 votes208 views2 answers
Postgresql database url
SQL
0 vote352 views1 answer
Hue hive UploadingTextFiletoHive
SQL
0 vote218 views1 answer
Safe mysql
SQL
0 vote206 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
2 votes200 views1 answer
Add 2 hours to current time in MySQL
SQL
1 vote201 views1 answer
Where date = max(date) in sql
SQL
0 vote193 views2 answers
Android sqlite tutorial for beginners
SQL
0 vote211 views1 answer
Kill thread
SQL
0 vote206 views1 answer
Mysql_union
SQL