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.
A Cube operator summarizes data of group by. It helps in determining subtotals
and grand totals.
This will display a summary of employees with same first name.
first_name, last_name, AVG(salary) FROM employee GROUP BY first_name WITH CUBE
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
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
Answer - Null means no entry has been made. It implies that the
value is either unknown or undefined.....