User Id :    Password :      New Member   Forgot Password  
Topic: Can you define ROLLUP in SQL SERVER 2005
Sachin Jain
29 Oct 2010 at 11:24 PM
Can you define ROLLUP in SQL SERVER 2005.

Re: Can you define ROLLUP in SQL SERVER 2005
Gaurav
01 Nov 2010 at 12:16 AM

ROLLUP clause is used to do aggregate operation on multiple levels in hierarchy. Let us understand how it works by using an example.


SELECT Country,[State],City,SUM ([Population (in Millions)]AS [Population (in Millions)]FROM tblPopulation
GROUP BY Country,[State],City WITH ROLLUP

Total Replies: 1
 
Featured Text Ad

Featured Ad