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 vote297 views1 answer
Mysql Selected All Duplicate Rows
SQL
0 vote273 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
0 vote279 views1 answer
Mssql now diff 90 day
SQL
0 vote276 views1 answer
Sql server size of every table in a db
SQL
3 votes295 views2 answers
Update Query in SQL Server
SQL
0 vote267 views1 answer
Sql remove last x char
SQL
2 votes309 views3 answers
How to check current user in mySQL
SQL
61 votes447 views6 answers
Mysql add column
SQL
1 vote299 views1 answer
Select users with same username
SQL
0 vote273 views1 answer
Mysql find missing values
SQL