SQL Server Interview Questions and Answers
<< Previous Question Next Question >>
 Question: 736 Page Views: 

What is the use of CUBE operator in SQL Server?



Posted By: Avi Date: 1 October 2010 12:14:08 PM
 Answer:

Cube operator is used with Group By clause to summarize the data. It helps in determining the sub total and grand totals. On the whole it usually present the data in aggregate form.


Posted By: avibtech


Date: 1 October 2010 12:14:08 PM
Post a better Answer if you have
 
(Will show your Gravatar icon)  
  Country flag

Loading
Enter the text as shown in the image hBCY9Q
Related Questions
SQL Server : Which Port is assigned to run SQL Server? Can the Default port be changed?

Which Port is assigned to run SQL Server? Can the Default port be changed?

1433 is the TCP/IP port which is required to run SQL Server . Yes, default port can be changed for ....
Category: SQL Server Date: 10/1/2010 10:54:06 AM
SQL Server : What is the maximum length of a varchar field in SQL Server?

What is the maximum length of a varchar field in SQL Server?

Variable-length data with a maximum of 8,000 characters.
Category: SQL Server Date: 10/30/2009 7:51:03 AM
SQL Server : What authentication mechanisms does Microsoft SQL Server support?

What authentication mechanisms does Microsoft SQL Server support?

SQL Server supports following two type of authentication mechanisms: 1) Windows Authentication (via....
Category: SQL Server Date: 10/15/2009 4:43:44 AM
SQL Server : What is the difference between UNION and UNION ALL Statements?

What is the difference between UNION and UNION ALL Statements?

UNION command selects distinct and related information from two tables while UNION ALL selects all t....
Category: SQL Server Date: 10/7/2009 3:19:40 AM
SQL Server : What is the difference between VARCHAR and NVARCHAR type?

What is the difference between VARCHAR and NVARCHAR type?

VARCHAR is a variable length string of ASCII characters while NVARCHAR is a variable length string o....
Category: SQL Server Date: 10/7/2009 3:09:18 AM