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

1 vote371 views1 answer
Mariadb.service: main process exited, code=exited, status=1/failure
SQL
0 vote334 views2 answers
Mysql output csv
SQL
0 vote353 views1 answer
Write a PL/SQL to print even numbers upto 100.
SQL
1 vote314 views1 answer
Unique vs distinct sql
SQL
0 vote372 views1 answer
Set default value now() date
SQL
1 vote385 views1 answer
Oracle insert multiple rows into same table
SQL
37 votes541 views3 answers
Sql check duplicate value in column
SQL
0 vote358 views1 answer
Sub query in linq
SQL
-1 vote355 views1 answer
MYSQL stored procedure select from
SQL
1 vote332 views1 answer
Mysql date diff in seconds
SQL