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

20 votes157 views6 answers
Creating a table in sql
SQL
0 vote134 views1 answer
Pgadmin see indexes
SQL
18 votes173 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
3 votes132 views1 answer
Sql select all
SQL
7 votes158 views6 answers
Group_concat in mysql
SQL
1 vote143 views3 answers
Read all columns of a table sql
SQL
0 vote150 views1 answer
Ffeathers express mysql application users login
SQL
31 votes146 views3 answers
Sql count(*)
SQL
6 votes144 views2 answers
How to get yesterday date in mysql
SQL
2 votes157 views1 answer
Sql get the name of user pc
SQL