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 vote166 views2 answers
Start mysql server using docker
SQL
3 votes295 views1 answer
Ssh check mysql version
SQL
32 votes170 views6 answers
Insert select
SQL
0 vote183 views1 answer
Mysql where in maintain order
SQL
0 vote189 views1 answer
Oracle list datafiles
SQL
0 vote166 views2 answers
Sql day from datetime
SQL
11 votes174 views2 answers
Oracle source code
SQL
1 vote192 views3 answers
Mysql on delete set null
SQL
0 vote171 views1 answer
Mysql change default collation
SQL
2 votes193 views5 answers
Tablespace ORACLE
SQL