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 vote313 views1 answer
How to delete duplicate rows in oracle
SQL
0 vote202 views1 answer
Mysql date time string format python
SQL
0 vote247 views1 answer
Mysql faster delete
SQL
0 vote191 views1 answer
Like sql for second letter of the family name
SQL
0 vote352 views1 answer
Sqlite display data in separated columns
SQL
2 votes214 views1 answer
Postgresql create schema in specific database
SQL
0 vote217 views1 answer
Add a new column into table
SQL
0 vote208 views1 answer
Mysql database hyphen
SQL
1 vote354 views1 answer
Mysql data from file
SQL
0 vote171 views1 answer
Query for maximum salary
SQL