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 vote316 views1 answer
Run mssql server terminal
SQL
0 vote376 views2 answers
Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. Your result cannot contain duplicates.
SQL
2 votes320 views1 answer
Set username and password for postgresql database
SQL
1 vote326 views1 answer
Postgresql export output table as a csv
SQL
2 votes331 views1 answer
Mysql application.properties spring boot
SQL
0 vote324 views1 answer
Mysql root permission denied lost
SQL
2 votes299 views1 answer
How to search table name in stored procedure in sql server
SQL
0 vote313 views1 answer
T sql check active deadlock
SQL
17 votes336 views6 answers
What is cursor in sql server with example
SQL
2 votes317 views2 answers
How to check data type in sql server
SQL