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



Latest Current Affairs 2024 Online Exam Quiz for One day Exam Online Typing Test CCC Online Test 2024 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