SELECT job_id "Job", COUNT(*) "#", MIN(salary) "MinSal", ROUND(AVG(salary), 0) "AvgSal", MEDIAN(salary) "Median", MAX(salary) "MaxSal", ROUND(STDDEV(salary)) "Std" FROM hr.employees GROUP BY job_id ORDER BY job_id
| SQL_MaxMinMed_STD1 |
SQL :
|
| Oracle only : stddev is not supported by PostgreSQL and MySQL
|