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

3 votes103 views2 answers
Mysql create database
SQL
1 vote100 views1 answer
$query = mysqli_query($con, $sql); while ($row = mysqli_fetch_array($query))
SQL
1 vote97 views2 answers
T sql get foreign key
SQL
7 votes117 views2 answers
Mysql check db size
SQL
0 vote60 views1 answer
Oracle list all stored procedures
SQL
-1 vote106 views1 answer
Select first rows postgresql
SQL
0 vote120 views1 answer
How to install Firebird
SQL
0 vote104 views1 answer
Print orcale
SQL
0 vote109 views1 answer
Liquibase update row
SQL
-1 vote110 views3 answers
Error mysql shutdown unexpectedly
SQL