/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

13 votes124 views2 answers
Mysql order by multiple columns
SQL
0 vote127 views1 answer
Sql datediff db2
SQL
2 votes98 views1 answer
Latest record in sql
SQL
0 vote307 views1 answer
Sql datum formatieren
SQL
5 votes130 views1 answer
Add column table sql default value
SQL
0 vote119 views1 answer
Which is the order of precedence among following operator IN OUT AND OR in sql
SQL
0 vote132 views1 answer
View to table
SQL
11 votes128 views3 answers
Sqlite3 create table from another table
SQL
0 vote116 views1 answer
QCompleter con sql
SQL
0 vote168 views1 answer
Call function sql oracle with output put line
SQL