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 vote134 views1 answer
Postgres get running query
SQL
0 vote115 views1 answer
Incorrect datetime value sql table error 1292
SQL
0 vote131 views1 answer
Sqlite commands
SQL
8 votes126 views6 answers
Sql insert
SQL
0 vote129 views1 answer
Download mysql database to excel in android studio
SQL
0 vote144 views2 answers
PostgreSQL having
SQL
0 vote154 views1 answer
Select top values sql
SQL
24 votes129 views4 answers
Postgres remove database
SQL
0 vote137 views2 answers
How to type a blank discord messgae
SQL
24 votes117 views2 answers
Alter table delete column
SQL