M

Mr. Dubey • 100.69K 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
Share
Explanation by: Mr. Dubey
ntile divides the partitioned result set into specified number of groups in an order.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Related MCQs

Q. If you were a lead developer of a software company and you are asked to submit a project/product within a stipulated time-frame with no cost barriers,

Q. 1. VPN is abbreviated as __________

Q. Sniffers can be prevented by using _______________

Q. UML is stands for

Q. TCP/IP port number 119/ 443 is assigned for .

Q. The deadlock state can be changed back to stable state by using statement.

Q. A collection of related instructions organized for a common purpose is referred to as

Q. Which of the following protocol is not an Internet Engineering Task Force standard?

Q. How many types of flip-flops are?

Q. Which of the following is true of all Perl scripts ?

Question analytics