select MIN(sal) "min", MAX(sal) "Max", ROUND(AVG(sal), 0) "AVG",round(stddev(sal), 2) "std" from emp WHERE JOB IN ('SALESMAN')
Job and salary of 'SALESMAN'
SQL :
select MIN(sal) "min", MAX(sal) "Max", ROUND(AVG(sal), 0) "AVG",round(stddev(sal), 2) "std" from emp WHERE JOB IN ('SALESMAN') |
| Oracle: Job and salary of 'SALESMAN'
|
| POSTGRESQL
|
| mYsql
|