Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
SELECT ROUND(my_count/cumulative_amount*1000000,2) FROM (SELECT SUM(val1) as my_count, fiscalMonth from tableA where flag=1 and fiscal_year=2013 group by fiscalMonth order by fiscalMonth), (SELECT SUM(SUM(amount)) OVER (ORDER BY fiscalMonth ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cumulative_amount from tableB where fiscalYear = 2013 group by fiscalmonth, order by fiscalmonth)
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Fill Null values||5||55|
|Oracle Query to Find number of process consumed by a session||15||71|
|Oracle programming for starter||14||75|
|Oracle function return value when null||2||34|
Join the community of 500,000 technology professionals and ask your questions.