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

5 votes209 views1 answer
How to check nls timestamp format in oracle
SQL
8 votes220 views1 answer
Mysql restore database
SQL
3 votes226 views3 answers
Order by postgres
SQL
1 vote228 views2 answers
Create table if not exist
SQL
8 votes227 views4 answers
How to calculate the age from date of birth in python
SQL
0 vote221 views1 answer
C# execute transact sql
SQL
0 vote218 views3 answers
Average salary in sql
SQL
0 vote235 views1 answer
Get initials name in sql
SQL
0 vote220 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL
7 votes204 views1 answer
Sql management studio display line numbers
SQL