Best example of grouping ???

Question

Post reply

Best example of grouping ???

vaibhav.tiwari

SSCommitted

Points: 1976
More actions
February 20, 2010 at 5:20 am

#386355

Hi everyone,
I want to get the best example of group by with cube rollupto understand as i m very confused between two ot them
Regards,
Vaibhav
Vaibhav K Tiwari
To walk fast walk alone
To walk far walk together

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Paul White SSC Guru Points: 150467 More actions · Answer 1

Using GROUP BY with ROLLUP, CUBE, and GROUPING SETS (Books Online)

Grouping Sets In SQL Server 2008 (Craig Freedman's Blog)

Those were my first two matches using Google Search.

Paul

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

RBarryYoung SSC Guru Points: 143329 More actions · Answer 2

vaibhav.tiwari (2/20/2010)
I want to get the best example of group by with cube rollupto understand as i m very confused between two ot them

What do you mean by "best"? What makes one example better than another for you?

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

Paul White SSC Guru Points: 150467 More actions · Answer 3

RBarryYoung (2/21/2010)
vaibhav.tiwari (2/20/2010)
I want to get the best example of group by with cube rollupto understand as i m very confused between two ot them
What do you mean by "best"? What makes one example better than another for you?

I might be going out on a limb here, but 'best' here seems to refer to the need to reduce the confusion level.

So, a clear, and easy-to-digest example might fit the bill?

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

vaibhav.tiwari SSCommitted Points: 1976 More actions · Answer 4

Yes paul you understood....

because over the internet a lot of material is available but its hard to get the best example sorry example which can easily differentiate the things to make me understand the concept if all the members think their example will make me clear step by step then they are welcome.....

Regards,

Vaibhav

Vaibhav K Tiwari
To walk fast walk alone
To walk far walk together

Kingston Dhasian SSCoach Points: 19799 More actions · Answer 5

Did you go through the links provided by Paul??

I don't think you will get any simpler examples than that. The Craig Freedman's Blog is pretty simple and easy to understand.

Kingston Dhasian

How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/

Paul White SSC Guru Points: 150467 More actions · Answer 6

Kingston Dhasian (2/22/2010)
The Craig Freedman's Blog is pretty simple and easy to understand.

Thanks for pointing that out. I thought Craig did an excellent job, but I was starting to think maybe I was wrong, and Vaibhav didn't find it useful...!

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi