SQL Server cube operator

Send request to get interview tips in PDF format Personal Interview - Answers to frequently asked questions Tips to earn promotions and perks You can also get your answers published How to write a good CV? How to write a good Cover Letter? Tips to become boss's favorite CareerRide is hiring

SQL Server cube operator interview questions

---

<<Previous  Next>>

Explain how to use Cube operator to summarize data.

Answer
A Cube operator summarizes data of group by. It helps in determining subtotals and grand totals.

Example: This will display a summary of employees with same first name.

Select first_name, last_name, AVG(salary) FROM employee GROUP BY first_name WITH CUBE

<<Previous  Next>>