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 vote293 views2 answers
Close external port 3306 with iptables
SQL
2 votes289 views1 answer
While loop sql
SQL
0 vote323 views2 answers
How to get max from each department in sql
SQL
1 vote303 views2 answers
Postgresql remote connect
SQL
2 votes335 views2 answers
Create temporary table in mysql
SQL
1 vote298 views1 answer
Postgresql must appear in the group by clause or be used in an aggregate function
SQL
0 vote303 views1 answer
Sql server get date of previous sunday
SQL
4 votes321 views2 answers
Oracle drop job
SQL
15 votes309 views4 answers
Mysql where value is null
SQL
0 vote298 views1 answer
How to reset table in sql server
SQL