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 vote287 views1 answer
Postgre query date
SQL
0 vote264 views1 answer
Rename constraint postgresql
SQL
0 vote278 views1 answer
Flask sqlalchemy. commit does not save changes
SQL
6 votes242 views3 answers
Mysql server is not starting xampp
SQL
1 vote267 views1 answer
Wherein mysql
SQL
0 vote257 views2 answers
Android sqlite query join
SQL
0 vote222 views1 answer
Grant owner postgresql
SQL
1 vote256 views1 answer
How to use a trigger to validate input data
SQL
0 vote285 views2 answers
Disallowed function mysql to_date()
SQL
0 vote291 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL