SELECT hire_date,
department_id,
job_id, salary,
LAG(salary) OVER (ORDER BY hire_date) salary_ant
FROM hr.employees
WHERE job_id = 'FI_ACCOUNT'| HIRE_DATE | DEPARTMENT_ID | JOB_ID | SALARY | SALARY_ANT | 16-AUG-02 | 100 | FI_ACCOUNT | 9000 | - | 28-SEP-05 | 100 | FI_ACCOUNT | 8200 | 9000 | 30-SEP-05 | 100 | FI_ACCOUNT | 7700 | 8200 | 07-MAR-06 | 100 | FI_ACCOUNT | 7800 | 7700 | 07-DEC-07 | 100 | FI_ACCOUNT | 6900 | 7800 |
|---|
SELECT hire_date,
department_id,
job_id,
salary,
LAG(salary) OVER (PARTITION BY department_id ORDER BY salary) salary_ant
FROM hr.employees
WHERE manager_id = 100| HIRE_DATE | DEPARTMENT_ID | JOB_ID | SALARY | SALARY_ANT | 17-FEB-04 | 20 | MK_MAN | 13000 | - | 07-DEC-02 | 30 | PU_MAN | 11000 | - | 16-NOV-07 | 50 | ST_MAN | 5800 | - | 10-OCT-05 | 50 | ST_MAN | 6500 | 5800 | 01-MAY-03 | 50 | ST_MAN | 7900 | 6500 | 18-JUL-04 | 50 | ST_MAN | 8000 | 7900 | 10-APR-05 | 50 | ST_MAN | 8200 | 8000 | 29-JAN-08 | 80 | SA_MAN | 10500 | - | 15-OCT-07 | 80 | SA_MAN | 11000 | 10500 | 10-MAR-05 | 80 | SA_MAN | 12000 | 11000 | 05-JAN-05 | 80 | SA_MAN | 13500 | 12000 | 01-OCT-04 | 80 | SA_MAN | 14000 | 13500 | 13-JAN-01 | 90 | AD_VP | 17000 | - | 21-SEP-05 | 90 | AD_VP | 17000 | 17000 |
|---|