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 vote322 views1 answer
Oracle list data files
SQL
0 vote348 views1 answer
Insert data from stored procedure into table
SQL
0 vote284 views0 answer
SQL
0 vote326 views1 answer
Odd record sql query
SQL
0 vote347 views1 answer
Arithmetic expression in sql
SQL
0 vote346 views1 answer
Oracle sql copy table without data
SQL
0 vote314 views2 answers
Get all index postgres
SQL
0 vote331 views1 answer
Postgres read table structure
SQL
0 vote407 views1 answer
Mysql get longest string in column
SQL
0 vote325 views1 answer
Match end of string regex sql
SQL