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 vote193 views1 answer
Delete from IN subquery
SQL
0 vote136 views1 answer
Python sqlalchemy orm to select null values
SQL
0 vote156 views1 answer
Sql order by except one row
SQL
0 vote148 views1 answer
Oracle sql add column auto generated value
SQL
5 votes185 views3 answers
Create function in postgresql
SQL
0 vote140 views1 answer
Mysql select smaller of two values
SQL
0 vote168 views1 answer
How to get table id sequence postgres
SQL
13 votes139 views2 answers
Oracle select into and inner join
SQL
0 vote137 views1 answer
Add multiple field in table sql
SQL
0 vote140 views1 answer
Insert array into mysql column
SQL