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



Online Exam Quiz for One day Exam Online Typing Test CCC Online Test 2026 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 Best Website and Software Company in Allahabad