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

5 votes354 views2 answers
Create function postgresql
SQL
0 vote369 views1 answer
Oracle cpu metric
SQL
3 votes377 views2 answers
Check data in table mysql
SQL
1 vote349 views1 answer
Find difference in dates sql
SQL
0 vote388 views1 answer
Pl sql disable trigger
SQL
4 votes319 views2 answers
Select todays data postgres query
SQL
1 vote360 views1 answer
Oracle create_program
SQL
0 vote338 views1 answer
Java spring boot connect to sql server
SQL
0 vote334 views1 answer
Increment id in mysql
SQL
0 vote336 views1 answer
Duplicate value unique constraint mysql error
SQL