SQL Server cube operator interview questions
Explain how to use Cube
operator to summarize data.
SQL Server Cube operator - Nov 20, 2008 at 18:00 PM
by Rajmeet Ghai
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>>
Also read
SQL
BETWEEN
SQL BETWEEN: The BETWEEN operator is used in a WHERE clause to
select a range of data between two values. The values can be
numbers, text, or dates..............
The IN operator allows you to specify multiple values in a WHERE
clause................
CUBE generates a result set that represents aggregates for all
combinations of values in the selected columns...........
Answer - SQL Server uses the following steps to
process a single SELECT statement....
Answer - CREATE DEFAULT, CREATE PROCEDURE,
CREATE RULE, CREATE TRIGGER, and CREATE VIEW statements....
Answer - GO Command is used to signal the end of
a batch.....
Answer - Null means no entry has been made. It implies that the
value is either unknown or undefined.....
|
