Q. Point out the wrong statement. (Solved)

1. rank() returns the rank of each row in the result set of partitioned column

2. dense_rank() is same as rank() function. only difference is returns rank without gaps

3. ntile() distributes the columns in an ordered partition into a specified number of groups

4. row_number() returns the serial number of the row order by specified column

  • c. ntile() distributes the columns in an ordered partition into a specified number of groups
Subscribe Now

Get All Updates & News