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 vote226 views1 answer
How to set field to null in sql
SQL
0 vote246 views1 answer
Ms Sql set us timezone
SQL
0 vote277 views1 answer
Postgres get database encoding
SQL
0 vote271 views1 answer
Mysql join only one column
SQL
8 votes267 views3 answers
Postgresql connection string c#
SQL
2 votes258 views2 answers
Checking data type in sql server
SQL
0 vote294 views1 answer
Sql query to find percentage of null values in a table
SQL
0 vote277 views1 answer
Close sql query vb.net
SQL
0 vote269 views1 answer
Sql select all records from all tables where not empty
SQL
7 votes273 views3 answers
Sql fill table with info from anothe rtable
SQL