您所在位置：主题：为什么在其它语言中可以用SUM，SETDEV等但不能用LAG为什么？？？
abc0chenming
[专家分：0] 发布于 2005-07-24 13:34:00
SELECT last_name, hire_date, salary,
LAG(salary, 1, 0) OVER (ORDER BY hire_date) AS prev_sal
FROM employees
WHERE job_id = 'PU_CLERK';
LAG(salary, 1, 0) OVER (ORDER BY hire_date) AS prev_sal
FROM employees
WHERE job_id = 'PU_CLERK';