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 vote180 views1 answer
Mariadb cast to int
SQL
0 vote228 views1 answer
Grouping by email domain mysql
SQL
3 votes184 views2 answers
Sql end of month
SQL
0 vote197 views1 answer
Update view sql
SQL
1 vote188 views1 answer
List all triggers in SQL Server
SQL
0 vote189 views1 answer
Sql find gaps in date ranges
SQL
2 votes185 views1 answer
While loop sql
SQL
5 votes199 views1 answer
Oracle asynchronous update
SQL
1 vote174 views1 answer
Stop mysql server mac
SQL
0 vote212 views1 answer
How to print sql query
SQL