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

11 votes285 views5 answers
Sql server reset identity
SQL
22 votes306 views3 answers
How to join three tables in sql using joins
SQL
32 votes288 views6 answers
Sql count where
SQL
0 vote276 views1 answer
Mysql select smaller of two values
SQL
0 vote286 views2 answers
Advantages of stored procedures sql
SQL
0 vote306 views1 answer
Distance calculator from lat long sql query
SQL
1 vote259 views2 answers
How to check username in mysql command line
SQL
13 votes261 views2 answers
Oracle inner join
SQL
0 vote333 views1 answer
Connect google bigquery connect using sqirrel
SQL
6 votes298 views3 answers
Create database mysql utf8
SQL