Working with SUB QURIES
select ename,sal from emp where sal > (select sal from emp where empno=7566)
select ename from emp where empno=7566
select ename from emp where ename like 'JON%'
select ename,sal from emp where sal > (select sal from emp where ename='JONES')
------------------------------------------------------------------------------------------------
SELECT ename, job,SAL FROM emp
WHERE job = (SELECT job FROM emp WHERE empno = 7369)
AND sal >(SELECT sal FROM emp WHERE empno = 7876);
------------------------------------------------------------------------------------------------
SELECT ENAME,SAL,JOB FROM EMP WHERE SAL=(SELECT MIN(SAL) FROM EMP)
--------------------------------------------------------------------------------------------------------------------------
SELECT deptno, MIN(sal) FROM emp GROUP BY deptno HAVING MIN(sal) >
(SELECT MIN(sal) FROM emp WHERE deptno = 20);
---------------------------------------------------------------------------------------------------------------------------
|