COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which of the following is not a window function?
|
|
MIN()
|
|
|
AVG()
|
|
|
DIFF()
|
|
|
COUNT()
|
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: -There are three main types of window functions available to use: aggregate, ranking, and value functions.
There is 1 question to complete.