nks,
ViSolve DB Team.
- Original Message -
From: "wangxu" <[EMAIL PROTECTED]>
To:
Sent: Thursday, December 21, 2006 8:29 AM
Subject: oracle transfer question
There is a oracle SQL:
SELECT employee_id, salary, hire_date, STDDEV(salary)
OVER (ORDER BY hire_date) "Std Deviati
There is a oracle SQL:
SELECT employee_id, salary, hire_date, STDDEV(salary)
OVER (ORDER BY hire_date) "Std Deviation of Salary"
FROM employees WHERE job_id = 'ST_CLERK';
The result is:
EMPLOYEE_ID SALARY HIRE_DATE Std Deviation of Salary
--- -- --
There is a oracle SQL:
SELECT employee_id, salary, hire_date, STDDEV(salary)
OVER (ORDER BY hire_date) "Std Deviation of Salary"
FROM employees WHERE job_id = 'ST_CLERK';
The result is:
EMPLOYEE_ID SALARY HIRE_DATE Std Deviation of Salary
--- -- --
