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

5 votes187 views1 answer
Sort order on two columns sql
SQL
1 vote221 views1 answer
How to give access to database in postgresql server to another user
SQL
0 vote173 views1 answer
Postgresql parse json array
SQL
0 vote179 views4 answers
Sql year
SQL
11 votes217 views6 answers
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
SQL
0 vote177 views1 answer
Delete double on SQL with multiple primary keys
SQL
1 vote197 views1 answer
Sql set auto increment back to 0
SQL
1 vote212 views1 answer
Oracle schema size
SQL
1 vote183 views1 answer
Duplicating a MySQL table with all the data Command
SQL
2 votes173 views1 answer
Sql create database
SQL