1Z0-909 Practice Questions - Oracle MySQL 8.0 Database Developer (1Z0-909) Exam

What does the LAG(salary, 2) window function return for a given row?

The salary value from the row two positions earlier in the partition The salary value from the row two positions later in the partition The sum of the previous two salaries The average of the previous two salaries

Correct Answer:

The salary value from the row two positions earlier in the partition

Access more questions from this quiz

Continue to 1Z0-909 Practice Questions - Oracle MySQL 8.0 Database Developer (1Z0-909) Exam for more practice questions and the full quiz experience.

Access More Questions