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 vote191 views1 answer
Mysql timediff
SQL
4 votes181 views3 answers
Oracle sql first day of quarter
SQL
0 vote197 views1 answer
Sql tablo hangi sp de
SQL
0 vote207 views1 answer
Mysql 3 months ago
SQL
0 vote187 views1 answer
Lesser than or equal to symbol in postgres
SQL
0 vote205 views1 answer
How to join result table in mysql
SQL
0 vote183 views1 answer
Cast float mysql
SQL
0 vote136 views2 answers
Jupyter notebook connect to database
SQL
0 vote187 views1 answer
How to add timestamp column in mysql
SQL
0 vote192 views1 answer
Select all columns except one sql
SQL