COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which of the following options is not a window function?
|
|
ROW ____ NUMBER()
|
|
|
SUM()
|
|
|
LEAD()
|
|
|
RUN ____ TOTAL()
|
Explanation:
Detailed explanation-1: -Explanation: Since SQL Server 2005 we have had support for some window functions, they are: ROW NUMBER, RANK, DENSE RANK and NTILE. 7. Which of the following is not a type of window function? Explanation: There is an aggregate window function available in SQL Server.
Detailed explanation-2: -A window function performs a calculation across a set of table rows that are somehow related to the current row. This is comparable to the type of calculation that can be done with an aggregate function.
Detailed explanation-3: -The SUM window function returns the sum of the input column or expression values. The SUM function works with numeric values and ignores NULL values.
There is 1 question to complete.