What is the difference between CUBE operator and ROLLUP operator?
Submitted by: AdministratorCUBE generates a result set that represents aggregates for all combinations of values in the selected columns.
ROLLUP generates a result set that represents aggregates for a hierarchy of values in the selected columns.
Submitted by: Administrator
ROLLUP generates a result set that represents aggregates for a hierarchy of values in the selected columns.
Submitted by: Administrator
Read Online SQL Server Architecture Job Interview Questions And Answers
Top SQL Server Architecture Questions
| ☺ | What do you know about system database? |
| ☺ | Explain the Microsoft SQL Server delete command? |
| ☺ | What is Model Database? |
| ☺ | Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? |
| ☺ | What is MSDB Database? |
Top New MS SQL Server Categories
| ☺ | SQL Server Database Administrator Interview Questions. |
| ☺ | SQL Server Service Broker Interview Questions. |
| ☺ | SQL Server Locks Interview Questions. |
| ☺ | SQL Server Constraints Interview Questions. |
| ☺ | MS SQL Data Mining Interview Questions. |
