I need help with a select statement which will order the rows per table, for a date column on that table
here is a select i tried:
SELECT EXTRACT(MONTH FROM date_column), COUNT(*)
FROM table name
GROUP BY EXTRACT(MONTH FROM date_column);
output recieved displayed months 1-12 with count per month
what about the years?????