Oracle sql group by date year

SELECT value1, extract(YEAR FROM my_date)
FROM my_table
GROUP BY value1, extract(YEAR FROM my_date);

Oracle sql group by date year

Select count(1), country_of_sale, to_char(datefield, 'YYYY-MM') AS yyyymm
from table 
where country_of_sale IN ('USA', 'EUROPE', 'ASIA')
group by country_of_sale, to_char(datefield, 'YYYY-MM')
order by to_char(datefield, 'YYYY-MM');

Source: stackoverflow.com

Similar codes

0 vote222 views1 answer
Mysql insert into select transaction c#
SQL
1 vote186 views1 answer
How to use a trigger to validate input data
SQL
2 votes200 views1 answer
Mysql add boolean column
SQL
5 votes231 views2 answers
Postgresql insert select
SQL
0 vote197 views1 answer
Alasql delete column
SQL
0 vote190 views1 answer
Sql view index
SQL
0 vote219 views1 answer
Character count sql
SQL
1 vote210 views1 answer
Import sql file mysql commadn line
SQL
0 vote319 views1 answer
Postgres list all stored procedures query
SQL
1 vote209 views1 answer
Mysql get max value and id
SQL