MCQ Answer

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

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

Topic : Database Fundamentals

A. Retrieves the previous value in a result set based on a specified order

B. Returns the next value in a result set based on a specified order

C. Calculates the average value for each group of rows

D. Counts the number of rows in a result set




Correct Answer is :

A. Retrieves the previous value in a result set based on a specified order



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