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 vote168 views1 answer
View to table sql
SQL
18 votes150 views6 answers
Mysql create table
SQL
0 vote141 views1 answer
Create function syntax sql server
SQL
0 vote149 views1 answer
Postgres create extension if not exists
SQL
0 vote177 views1 answer
Check database restore status sql script
SQL
0 vote178 views1 answer
Mysql auto increment in DD-MM-XXX format
SQL
0 vote147 views1 answer
To change the database owner in SQL server
SQL
0 vote149 views1 answer
Get all employees if name ends with in sql
SQL
3 votes148 views1 answer
Sql case update
SQL
2 votes201 views2 answers
Postgres drop column if exists
SQL