Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT ename, sal FROM EMP WHERE sal > any (SELECT sal FROM EMP WHERE deptno = '30');
- SELECT ename, sal FROM EMP WHERE sal > all (SELECT sal FROM EMP WHERE deptno = '30');
- SELECT avg(sal), deptno FROM EMP Group by deptno having avg(sal) > (SELECT avg(sal) FROM EMP where deptno = 30);
- SELECT JOB FROM emp group by JOB having avg(sal) >= all (select avg(sal) FROM EMP group by job);
- select ename, sal from emp where sal > (
- select max(sal) from emp
- inner join dept on dept.deptno = emp.deptno
- where dept.dname = 'SALES'
- );
- select ename, sal, job from emp where job = (select job from emp where empno = 7369) and sal > (select sal from emp where empno = 7876);
- --select distinct dname from emp
- --inner join dept on emp.deptno = dept.deptno
- -- where job = 'CLERK';
- select dname from dept where deptno in (select deptno from emp where job = 'CLERK');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement