Answers for "ORACLE COUNT GROUP BY YEAR"

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 COUNT GROUP BY YEAR"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "ORACLE COUNT GROUP BY YEAR"

Code answers related to "ORACLE COUNT GROUP BY YEAR"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "ORACLE COUNT GROUP BY YEAR"

Code answers related to "ORACLE COUNT GROUP BY YEAR"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us