• Home
  • Blog
  • What does the rollup subclause provide in terms of grouping and how does it differ from the CUBE subclause?

What does the rollup subclause provide in terms of grouping and how does it differ from the CUBE subclause?

0 comments

ORDER YOUR PAPER AND GET QUALITY FOR YOUR MONEY

Learning Goal: I’m working on a mysql question and need an explanation and answer to help me learn.Complete the following exercise: Using the ABC Markets SQL database, write the SQL code to select the invoice year from inv_date with the column name invoiceYear, the invoice month from inv_date with the column name invoiceMonth, the invoice day from inv_date with the column name invoiceDay, and the sum of the invoice total with the column name invoiceTotal from the invoice table. Group the results by year, month, and day using the ROLLUP subclause.Using ABC Markets SQL database and line table, write the SQL code to select the invoice number, line number and the sum of the line price as sumLP. Group the results using grouping sets of invoice number and line number to show the sumLP by invoice number order.QUESTION: What does the rollup subclause provide in terms of grouping and how does it differ from the CUBE subclause?QUESTION: What is the purpose of the GROUPING SETS subclause and what is its primary use?Once you have completed your assignment, copy and paste the script into a Word document and submit it.

About the Author

Follow me


{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}