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

12 votes197 views4 answers
Mysql version
SQL
0 vote188 views1 answer
What is metadata in sql
SQL
0 vote168 views1 answer
Lister les index d'une table oracle
SQL
6 votes174 views1 answer
Oracle rank() over (partition)
SQL
0 vote201 views1 answer
Mysql local password denied
SQL
0 vote219 views1 answer
Get relation data in mysql using query to excel
SQL
0 vote193 views1 answer
Interview experience as a call?
SQL
22 votes196 views3 answers
Remove all records from table mysql
SQL
0 vote214 views1 answer
Oracle date summer time
SQL
0 vote217 views1 answer
Sqlalchemy query join many to many
SQL