SQL_GroupBy1

SQL_GroupBy1.htm

Testing Script :

SELECT JOB, ROUND(AVG(SAL), 2) FROM emp where job = 'SALESMAN' GROUP BY JOB

SELECT JOB, ROUND(AVG(SAL), 2)as avgsal FROM emp where job = 'SALESMAN' GROUP BY JOB

Oracle: PostgreSQL: MySQL :

Postgresql;

Oracle

MySQL