M

Mr. Dubey • 52.30K 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
Correct : Option (A)

Explanation: 
 order by clause is not optional clause in row number function.

Share

Discusssion

Login to discuss.

Loading Comments....

Related MCQs

Q. What is the default order of Order by clause?

Q. IoT is a paradigm that involves ubiquitous presence in the environment

Q. Informing to the developer which bug to be fix first is called as

Q. Which of the following is NOT a namespace in the .NET Framework Class Library?

Q. TCP/IP port number 118/ 156 is assigned for .

Q. The ____________ is often employed when there is a need to use different sets of objects and where the objects could be added or changed some time dur

Q. UML is useful to ________ a system as it is or as we want it to be.

Q. Which scheduling algorithm allocates the CPU first to the process that requests the CPU first?

Q. E-mail is

Q. Which statement is valid about interpreter?