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 vote155 views1 answer
Oracle index hint multiple tables example
SQL
4 votes173 views3 answers
Rename table column postgresql
SQL
0 vote175 views1 answer
Kill a pid redshift
SQL
5 votes173 views1 answer
Oracle list functions
SQL
6 votes165 views1 answer
Sql insert values into table
SQL
14 votes186 views6 answers
Auto_increment mysql
SQL
7 votes169 views2 answers
Get database size mysql
SQL
0 vote186 views1 answer
Sql statement show all emails with dome
SQL
-1 vote192 views1 answer
Mysql select count if contains
SQL
0 vote166 views1 answer
Mysql command prompt date insert format
SQL