McqMate
| Q. |
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» C. ntile() distributes the columns in an ordered partition into a specified number of groups | |
| Explanation: ntile divides the partitioned result set into specified number of groups in an order. | |
View all MCQs in
Information Retrival TechniquesNo comments yet