COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
NUMBER()
|
|
|
RANK()
|
|
|
ROW ____ NUMBER()
|
|
|
DENSE ____ RANK()
|
Detailed explanation-1: -3. Which of the following is not a mathematical function? Explanation: SQL Server has CEILING function to get the smallest integer greater than the specified expression. Sanfoundry Certification Contest of the Month is Live.
Detailed explanation-2: -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-3: -In SQL, there are basically two types of window functions – Aggregate window functions and analytical window functions. Analytical Window Functions – These types of functions are used to calculate some window based on the current row and then calculate the results based on that window of records.