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

11 votes156 views2 answers
Oracle source code
SQL
37 votes200 views6 answers
Mysql update
SQL
1 vote157 views1 answer
Pl sql ptint
SQL
6 votes149 views5 answers
Mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'
SQL
0 vote176 views1 answer
Mariadb.service failed with result 'exit-code'
SQL
0 vote120 views1 answer
Mysql offset from bottom
SQL
-1 vote168 views1 answer
Mysql select count if contains
SQL
1 vote175 views1 answer
Postgresql datetrunc too slow
SQL
0 vote169 views1 answer
Postgres reorder columns
SQL
2 votes156 views1 answer
How to check if a row is null in sql
SQL