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

1 vote408 views1 answer
STOP message of how many rows affected sql
SQL
0 vote309 views1 answer
Declaring variables in pl sql
SQL
2 votes343 views3 answers
How to get second highest salary in each department in sql
SQL
0 vote327 views1 answer
Mysql select last 15 minutes
SQL
0 vote337 views1 answer
Dump multiple tables mysql
SQL
0 vote329 views1 answer
Aktor yang pernah terlibat di film bergenre Aksi di sql
SQL
3 votes325 views1 answer
Oracle rollback
SQL
11 votes334 views2 answers
Turn off safe mode mysql
SQL
0 vote350 views1 answer
Sql if clause within where clause
SQL
0 vote344 views1 answer
How to search query in python3 sqlite3
SQL