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 vote297 views1 answer
Oracle sql count occurrences of value in column
SQL
0 vote273 views1 answer
Sql orcale i forgot what my name & password was
SQL
0 vote305 views1 answer
How to get nth number in sql
SQL
8 votes394 views2 answers
Select current_timestamp - interval '3 days';
SQL
3 votes288 views1 answer
Mysql set field unique
SQL
1 vote280 views1 answer
How to get mysql db size
SQL
0 vote292 views1 answer
Sql on-premises
SQL
0 vote296 views1 answer
Logtash mysql cofiguration file
SQL
0 vote294 views1 answer
Insensitive case match sqlalchemy
SQL
0 vote334 views1 answer
Mysql update column default value CURRENT_TIMESTAMP error
SQL