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

31 votes223 views3 answers
Sql count(*)
SQL
4 votes231 views2 answers
How to insert ip address in mysql using php
SQL
0 vote251 views2 answers
Homebrew nysql launch
SQL
1 vote225 views2 answers
Postgresql backup and restore globals and data
SQL
-1 vote234 views1 answer
How to switch user in mysql
SQL
0 vote226 views1 answer
Add plugins to mysql workbench
SQL
6 votes251 views3 answers
Mysql remove user privileges
SQL
0 vote274 views1 answer
Influxdb list all tags for a measurement
SQL
0 vote240 views1 answer
Set classpath for mysql-connector.jar
SQL
0 vote218 views1 answer
Mysql regex exact match
SQL