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 vote195 views1 answer
Disableforiegn key check
SQL
1 vote213 views1 answer
Oracle repeat_interval 5 minutes
SQL
1 vote187 views1 answer
Sequence item 6 expected str instance bytes found mysql workbench
SQL
1 vote215 views1 answer
Sql drop schema
SQL
3 votes184 views3 answers
Docker create postgresql database
SQL
0 vote223 views1 answer
Select nth row in mysql
SQL
3 votes221 views2 answers
Update Query in SQL Server
SQL
1 vote202 views1 answer
Local sql server
SQL
7 votes215 views2 answers
Postgres concat
SQL
0 vote188 views1 answer
Import sql mysql ubuntu
SQL