M

Mr. Dubey • 100.69K Points
Coach

Q. Which of the following error message will be displayed if ORDER CLAUSE is not mentioned in ROW NUMBER function?

  • (A) “the ranking function “row_number” must have an order by clause.”
  • (B) “the ranking function “row_number” must have an over by clause.”
  • (C) “the ranking function “row_number” must have an partition by clause.”
  • (D) all of the mentioned
Share
Explanation by: Mr. Dubey
order by clause is not optional clause in row number function.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Related MCQs

Q. What are the two kinds of semaphores?

Q. Steps in boot process

Q. First types of pervasive communication networks were

Q. If there is only a discrete number of possible outcomes called .

Q. Purpose of process is to deliver software

Q. Which application feature is a world of warcraft gadget?

Q. One of the popular mass storage device is CD ROM. What does CD ROM stand for?

Q. The number of possible ordered trees with three nodes A,B,C is?

Q. the number of inputs connected to the gate without any degradation in the

Q. Matrices with a relatively high proportion of zero entries are called _______ matrices.

Question analytics