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

57 votes2.2K views5 answers
How to create a new user in postgresql
SQL
0 vote186 views1 answer
Mysql undo delete
SQL
0 vote191 views1 answer
Sql server select record with max id
SQL
0 vote233 views1 answer
Create-table-with-index-organization
SQL
0 vote211 views1 answer
Oracle string length
SQL
21 votes158 views7 answers
Table drop if exist sql server
SQL
6 votes203 views1 answer
SQL insert all columns
SQL
22 votes201 views4 answers
Mysql date_format
SQL
3 votes252 views2 answers
Find string in stored procedure sql server
SQL
0 vote203 views1 answer
Enable sql server full text indexing
SQL