|
SELECT AVG(SAL),SUM(SAL),MIN(SAL),MAX(SAL) FROM EMP WHERE JOB LIKE 'SALES%'
SELECT * FROM EMP WHERE JOB='SALESMAN';
SELECT ENAME,HIREDATE FROM EMP;
SELECT ENAME,MIN(HIREDATE),MAX(HIREDATE) FROM EMP;
select ename from emp where hiredate=min(hiredate)
SELECT MAX(SAL) FROM EMP WHERE JOB LIKE 'SALES%'
SELECT ENAME FROM EMP WHERE SAL=(SELECT MAX(SAL) FROM EMP WHERE JOB LIKE 'SALES%')
SELECT MIN(HIREDATE)FROM EMP;
SELECT ENAME,HIREDATE FROM EMP WHERE HIREDATE=(SELECT MIN(HIREDATE)FROM EMP)
SELECT COUNT(*) FROM EMP WHERE DEPTNO=30
SELECT COUNT(*) FROM EMP WHERE JOB LIKE 'SALES%'
SELECT AVG(COMM) FROM EMP
SELECT AVG(NVL(COMM,0)) FROM EMP
SELECT DEPTNO,AVG(SAL) FROM EMP GROUP BY DEPTNO;
SELECT SAL FROM EMP WHERE DEPTNO=10
SELECT DEPTNO,MAX(SAL) FROM EMP GROUP BY DEPTNO HAVING MAX(SAL) > 2900
SELECT job, SUM(sal) FROM emp WHERE job NOT LIKE 'SALESMAN'
GROUP BY job HAVING SUM(SAL) >= 5000
SELECT MAX(avg(sal)) FROM emp GROUP BY deptno;
SELECT MAX(avg(sal)) FROM emp GROUP BY deptno
SELECT DEPTNO FROM EMP GROUP BY DEPTNO HAVING AVG(SAL) = (SELECT MAX(avg(sal)) FROM emp GROUP BY deptno)
SELECT DEPTNO FROM EMP WHERE AVG(SAL)=5000
SELECT MAX(avg(sal)) FROM emp
|
