Hi,
Try using STDDEV(), which was given for Oracle compatibility by MySQL.
SELECT employee_id, salary, hire_date, STDDEV(salary) "Std Deviation of
Salary" FROM employees WHERE job_id = 'ST_CLERK' Group by employee_id,
salary, hire_date ORDER BY hire_date;
Thanks,
ViSolve DB Team.
- Origin
meridklt wrote:
>
> I'm working through (my first day) PHP & MySQL for Dummies and I'm stuck
> on the primary field for my database.
> I want to create a racing pigeon results database that has 6 fields only.
> The results will be imported into the database in bulk from a CSV file
> Owner - GBr
>
> I'm working through (my first day) PHP & MySQL for Dummies and I'm stuck
on
> the primary field for my database.
> I want to create a racing pigeon results database that has 6 fields only.
> The results will be imported into the database in bulk from a CSV file
> Owner - GBring - Ering - Arri
[snip]
I'm working through (my first day) PHP & MySQL for Dummies and I'm stuck
on
the primary field for my database.
I want to create a racing pigeon results database that has 6 fields
only.
The results will be imported into the database in bulk from a CSV file
Owner - GBring - Ering - Arrivedtime
