COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
RANK()
|
|
|
ROW ____ NUMBER()
|
|
|
DENSE ____ RANK()
|
|
|
NTILE()
|
Detailed explanation-1: -The DENSE RANK window function determines the rank of a value in a group of values, based on the ORDER BY expression in the OVER clause. If the optional PARTITION BY clause is present, the rankings are reset for each group of rows. Rows with equal values for the ranking criteria receive the same rank.
Detailed explanation-2: -IsDate returns True if the expression is a date or is recognizable as a valid date; otherwise, it returns False.
Detailed explanation-3: -But unlike regular aggregate functions, use of a window function does not cause rows to become grouped into a single output row-the rows retain their separate identities. Behind the scenes, the window function is able to access more than just the current row of the query result.