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

1 vote87 views1 answer
Alter user mysql native password
SQL
0 vote146 views1 answer
Error code 1451 sql
SQL
0 vote133 views1 answer
Mysql select smaller of two values
SQL
2 votes160 views1 answer
Insert from table tsql
SQL
0 vote127 views1 answer
Fill up postgres db
SQL
22 votes144 views3 answers
Remove all records from table mysql
SQL
5 votes139 views2 answers
Mysql import gzip db
SQL
1 vote322 views1 answer
Foreign key in oracle sql developer
SQL
0 vote135 views1 answer
Why mysql is used?
SQL
3 votes122 views1 answer
Start mysql server linux terminal
SQL