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

2 votes418 views1 answer
Mysql shell insert into
SQL
0 vote384 views1 answer
Sql make sure every user is unqiuew
SQL
2 votes357 views1 answer
Check isolation level in mysql
SQL
0 vote447 views1 answer
HOW to select specific table data from an mysql databse server:
SQL
0 vote396 views1 answer
Psql check if sql script is valid
SQL
3 votes388 views4 answers
Psql list tables in schema
SQL
0 vote372 views1 answer
In query in sql
SQL
0 vote343 views1 answer
IS THEre any difference between using default and := in plsql
SQL
0 vote383 views1 answer
Load data from text file to mysql database on mac terminal
SQL
0 vote346 views1 answer
Mssql describe stored procedure sqlcmd
SQL