MCQ Answer

What is the purpose of the SQL ROW_NUMBER() window function?

What is the purpose of the SQL ROW_NUMBER() window function?

Topic : Database Fundamentals

A. To count the total number of rows in a result set

B. To assign a unique number to each row within a partition of a result set

C. To retrieve the row with the maximum value in a column

D. To calculate the average value of a column




Correct Answer is :

B. To assign a unique number to each row within a partition of a result set



CCC Online Test 2021 CCC Practice Test Hindi Python Programming Tutorials Best Computer Training Institute in Prayagraj (Allahabad) Best Java Training Institute in Prayagraj (Allahabad) Best Python Training Institute in Prayagraj (Allahabad) O Level Online Test in Hindi Bank SSC Railway TET UPTET Question Bank career counselling in allahabad Sarkari Naukari Notification Best Website and Software Company in Allahabad Sarkari Exam Quiz