Which of the following syntax for window functions is accurate SELECT AVG SALARY OVER PARTITION BY DEPARTMENT ID ORDER BY SALARY

Question

Which of the following syntax for window functions is accurate SELECT AVG SALARY OVER PARTITION BY DEPARTMENT ID ORDER BY SALARY AS TOTAL SALARY FROM EMPLOYEES SELECT AVG SALARY OVER ORDER BY SALARY PARTITION BY DEPARTMENT ID AS TOTAL SALARY FROM EMPLOYEES SELECT AVG SALARY OVER PARTITION BY DEPARTMENT ID ORDER BY SALARY AS TOTAL SALARY FROM EMPLOYEES SELECT AVG SALARY OVER BY PARTITION BY SALARY ORDER BY DEPARTMENT ID AS TOTAL SALARY FROM EMPLOYEES

Kunduz · Accepted Answer

Click to see the answer