Q1. What is Rollup? Answer. ROLLUP produces group subtotals from right to left and a grand total. If “n” is the number of columns listed in the ROLLUP, then there will be n+1 levels of subtotals. FACT1_ID FACT2_ID SALES_VALUE 1 1 4363.55 1 2 4794.76 1 3 4718.25 1 4 5387.45 1 5 5027.34 1Continue reading “Analytical Functions”
All about Oracle SQL & PL/SQL
TechOraFAQ 