Answers for "Oracle group by range date"

SQL
4

oracle sql group by date year

SELECT value1, extract(YEAR FROM my_date)
FROM my_table
GROUP BY value1, extract(YEAR FROM my_date);
Posted by: Guest on May-02-2021
0

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');
Posted by: Guest on February-17-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language