您所在位置：主题：为什么在BCB的QUERY里不能用SQL的函数？如LAG等。
abc0chenming
[专家分：0] 发布于 2005-07-24 13:31: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';
