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 vote144 views1 answer
Postgres start database on linux
SQL
1 vote142 views1 answer
Sql server epoch to datetime
SQL
4 votes134 views1 answer
Oracle error line
SQL
0 vote146 views1 answer
How to check common records in 2 table
SQL
0 vote162 views1 answer
Import sql inside hide sql
SQL
0 vote118 views1 answer
Alter boolean column postgresql
SQL
0 vote148 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
3 votes149 views1 answer
Select sequence oracle
SQL
0 vote130 views1 answer
Postgresql heritage
SQL
1 vote146 views1 answer
Sql select whole row max column
SQL