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 vote209 views3 answers
How to restart mysql in linux
SQL
5 votes203 views3 answers
Sql max value in column
SQL
2 votes198 views1 answer
Oracle list duplicates
SQL
9 votes185 views2 answers
Convert data type in sql
SQL
1 vote199 views3 answers
Showing all columns in an sqlite table
SQL
0 vote197 views1 answer
Add SuperUser MySQL
SQL
0 vote196 views1 answer
Create table with float datatype in sql server
SQL
0 vote185 views1 answer
Number(10 2) in sql means
SQL
1 vote196 views1 answer
Alter add syntax
SQL
0 vote193 views1 answer
Grant access on table in oracle
SQL