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 vote324 views1 answer
If exist column in table drop sql query mysql
SQL
15 votes337 views7 answers
MYSQL
SQL
0 vote330 views1 answer
Update one column from another column in same table
SQL
16 votes344 views2 answers
Mysql date between two dates
SQL
0 vote324 views2 answers
How to type a blank discord messgae
SQL
1 vote355 views2 answers
Mysql extract number from string
SQL
7 votes335 views1 answer
Return insert results in POSTGRESQL
SQL
0 vote308 views1 answer
Postgres select except
SQL
0 vote351 views1 answer
Spark sql grows beyond 64 kb
SQL
0 vote348 views1 answer
Check if record exists mysql
SQL