Point out the wrong statement :
A. RANK() returns the rank of each row in the result set of partitioned column.
B. DENSE_RANK() is same as RANK() function. Only difference is returns rank without gaps.
C. NTILE() distributes the columns in an ordered partition into a specified number of groups.
D. ROW_NUMBER() returns the serial number of the row order by specified column.
Answer:A
Point out the wrong statement :
A. RANK() returns the rank of each row in the result set of partitioned column. B. DENSE_RANK() is same as RANK() function. Only difference is returns rank without gaps. C. NTILE() distributes the columns in an ordered partition into a specified number of groups. D. ROW_NUMBER() returns the serial number of the row order by specified column.
Explanation:NTILE divides the partitioned result set into specified number of groups in an order.