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 vote299 views1 answer
Mysql is odd
SQL
0 vote216 views2 answers
Select last 30 days sql
SQL
0 vote202 views2 answers
Sql join on wildcard
SQL
0 vote235 views1 answer
Mysql delete from where like
SQL
0 vote192 views1 answer
Plpgsql coalesce equivalent for empty string
SQL
0 vote210 views2 answers
Get all index postgres
SQL
0 vote317 views1 answer
Dockerfile example for Django
SQL
3 votes194 views2 answers
Mysql add 2 hours
SQL
2 votes265 views2 answers
Mysql date range
SQL
0 vote210 views1 answer
DELETE DUPLICATE VALUES FROM A TABLE IN SQL SERVER
SQL