Top "Rollup" questions

The ROLLUP operator is useful in generating reports that contain subtotals and totals.

How to automatically insert a blank row after a group of data

I have created a sample table below that is similar-enough to my table in excel that it should serve to …

excel vba rollup blank-line
Add a summary row with totals

I know this sounds crazy and probably should not be done this way but I need something like this - …

sql sql-server rollup
Sum with SQL server RollUP - but only last summary?

I have this query: DECLARE @t TABLE(NAME NVARCHAR(MAX),datee date,val money) insert INTO @t SELECT 'a','2012…

sql-server sql-server-2008 sum rollup
When to use GROUPING SETS, CUBE and ROLLUP

I have recently learned about GROUPING SETS, CUBE and ROLLUP for defining multiple grouping sets in sql server. What I …

sql sql-server grouping cube rollup
oracle rollup function with multiple columns

I've a simple query: WITH data(val1, val2, val3) AS ( SELECT 'a' ,'a-details' ,'1' FROM DUAL UNION ALL SELECT …

sql oracle rollup
Alias names to with rollup in SQL queries?

I am using with rollup in my sql query. I am not getting alias name for rollup. My SQL is …

sql tsql stored-procedures sql-server-2008-r2 rollup
SQL SERVER T-SQL Calculate SubTotal and Total by group

I am trying to add subtotal by group and total to a table. I've recreated the data using the following …

sql sql-server tsql subtotal rollup
What is the difference between cube, rollup and groupBy operators?

Question is pretty much in the title. I can't find any detailed documentation regarding the differences. I do notice a …

sql apache-spark apache-spark-sql cube rollup
how to include use of node_modules in rollup compile

I repeatedly get this message and I am trying to include the d3.js into my distribution file. Treating 'd3.…

javascript d3.js rollup
Uncaught TypeError: this.method is not a function - Node js class export

I am new to node.js and I am trying to require a class. I have used https://developer.mozilla.…

javascript node.js electron rollup