My assignment question is (using the Pubs database):
Create another query but instead of the compute use the Rollup, and then use the CUBE. How are these different from the COMPUTE? Explain your answer.

What I have done is:
SELECT type, AVG (price)
FROM titles
GROUP BY type WITH ROLLUP

SELECT type, AVG (price)
FROM titles
GROUP BY type WITH CUBE

I don’t think I did this correctly tho because my results didn’t appear to change.

Did I use the Rollup and/or Cube incorrectly?

Hi Jinn,

Take a look at SQL Server's Books Online. There's lots of information about ROLLUP and CUBE in the index under "CUBE operator" and "ROLLUP operator".

The examples in these topics should be enough to explain the difference and help you out.

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

With only a single column in a GROUP BY, Rollup and Cube will show the same thing... try these queries, instead...

SELECT City,State,COUNT(*)
FROM STORES
GROUP BY City,State WITH ROLLUP

SELECT City,State,COUNT(*)
FROM STORES
GROUP BY City,State WITH CUBE

--Jeff Moden