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 vote314 views1 answer
Less than date query sqlachemy
SQL
1 vote316 views1 answer
Get create table query existing table mysql
SQL
1 vote317 views1 answer
Mysql add fields
SQL
12 votes279 views4 answers
SQL Where
SQL
0 vote344 views1 answer
Sql statement show all emails with dome
SQL
0 vote288 views1 answer
Como verificar registros duplicados no sql postgresql
SQL
6 votes342 views2 answers
Foreign key sqlite3 python
SQL
3 votes370 views2 answers
Oracle drop sequence
SQL
0 vote296 views1 answer
Duplicate value unique constraint mysql error
SQL
-1 vote323 views1 answer
Select first rows postgresql
SQL