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 vote212 views1 answer
Delete mysql ubuntu 20.04
SQL
2 votes203 views1 answer
Dbms transaction (psql)
SQL
0 vote188 views1 answer
Load data infile mariadb slow
SQL
1 vote181 views1 answer
Oracle sql pad left zeros
SQL
0 vote333 views1 answer
Multiple row join
SQL
-1 vote167 views1 answer
Get id from just inserted row mysql server python
SQL
1 vote157 views1 answer
Sql server select rows by distinct column
SQL
0 vote166 views1 answer
How to find columns with null values in sql
SQL
0 vote166 views1 answer
Oracle remove line breaks
SQL
0 vote154 views1 answer
Minecraft duping allowed servers
SQL