M

Mr. Dubey • 52.30K Points
Coach 

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
Correct : Option (C)

Explanation: 
 ntile divides the partitioned result set into specified number of groups in an order.

Share

Discusssion

Login to discuss.

Be the first to start discuss.

Related MCQs

Q. A polygon with 12 sides can be triangulated into

Q. SSL provides .

Q. Which design pattern you would you use to limit the class instantiation to one object?

Q. Left hand side of a production in CFG consists of:

Q. Service Provision Life-Cycle - Maintenance Phase .........

Q. Who gave the expression for the probability and expected value of gcd?

Q. Symmetric key encryption is also called as?

Q. Which piece of information is not vital for a computer in a TCP/IP network?

Q. Who invented Analytical engine?

Q. which one of the following is the first spreadsheet application?