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 vote136 views1 answer
Install mysql 5.7 ubuntu 20.04
SQL
22 votes126 views3 answers
Join three tables sql
SQL
0 vote123 views2 answers
Many to many flask-sqlalchemy
SQL
0 vote158 views1 answer
Shortcut run sql pgadmin
SQL
1 vote147 views1 answer
Mysql not supported auth mode
SQL
0 vote131 views1 answer
6)selects only the DISTINCT values from the "side" column in the "Reserves" table
SQL
5 votes137 views3 answers
Truncate function in sql oracle
SQL
4 votes141 views1 answer
Oracle nls_date_format
SQL
0 vote142 views1 answer
Sql sum show 0 result
SQL
-1 vote147 views1 answer
Mysql coalesce
SQL