M

Mr. Dubey • 52.30K Points
Coach 

Q. Which of the following is the simplest ranking function?

(A) rank
(B) ntile
(C) row_number
(D) none of the mentioned
Correct : Option (C)

Explanation: 
 the row_number ranking function is the simplest of the ranking functions.its purpose in life is to provide consecutive numbering of the rows in the result set by the order selected in the over clause for each partition specified in the over clause.

Share

Discusssion

Login to discuss.

Be the first to start discuss.

Related MCQs

Q. Management is multidimensional because it has ___ dimension(s).

Q. Objects of the string class

Q. >8, 4>2, 1>2])

Q. An effective to introduce parallelism in memory access is by

Q. (65.535)10 =(X)16 FIND X

Q. GAs were developed in the early _____________.

Q. Corrupted index file is corrected using

Q. A method of helping is to understand management and organisational behaviour is to look at that has been done before

Q. p V ~(p٨q) is….

Q. The port number is “ephemeral port number”, if the source host is _______