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
I had been asked this question by my college director while I was bunking the class.
My question is based upon Ranking in division Manipulating Data with Select of SQL Server