Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 Transact-SQL (2012)
 Grouping with ROLLUP

Author  Topic 

geekgirl65
Starting Member

2 Posts

Posted - 2013-11-06 : 17:12:29
I am studying for the 70-461 exam and am not finding very good documentation on when to use the specific combinations of ROLLUP.
I was taking practice exam and can't get it right, and I didn't see any of the answers that made sense.
Specifically when to use the ROLLUP outside the Grouping parentheses or inside, to get a group of subtotals for 2 out of the 5 totals columns.
Any advice or better description than in the Developer Documentation?
Thanks!

Renee

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-11-07 : 04:31:36
http://databases.about.com/od/sql/l/aacuberollup.htm

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

sz1
Aged Yak Warrior

555 Posts

Posted - 2013-11-13 : 06:34:26
See simple ROLLUP here:
http://blog.sqlauthority.com/2010/02/24/sql-server-introduction-to-rollup-clause/


SZ1
Please help me to enable me to help others!
Go to Top of Page
   

- Advertisement -