Answers for "oracle group by month and year from 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');

Posted by: Guest on February-17-2020

Code answers related to "oracle group by month and year from date"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "oracle group by month and year from date"

Code answers related to "oracle group by month and year from date"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "oracle group by month and year from date"

Code answers related to "oracle group by month and year from date"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us