Oracle Book_01 Practice 07 solution. 

1. SQL> SELECT ename, deptno, sal

  2 FROM emp

  3 WHERE (sal, deptno) IN

  4 (SELECT sal, deptno from emp);

2. SQL>

  2 SELECT ename, dname, sal

  3 FROM emp e, dept d

  4 WHERE e.deptno = d.deptno

  5 AND (sal, NVL(comm,0)) IN (SELECT sal, NVL(comm,0) FROM emp e, dept d);

3. SQL> SELECT ename, hiredate, sal

  2 FROM emp

  3 WHERE (sal, NVL(comm,0)) IN

  4 (SELECT sal, NVL (comm, 0)

  5 FROM emp where ename = ' SCOTT ' );

4. SQL> SELECT ename , job, sal

  2 FROM emp

  3 WHERE sa l > ALL (SELECT sal

  4 FROM emp where job= 'CLERK');

 

 

 

Thanks To Mr:- Marcosoft 

For anything ask,just whatsapp contact me via my email 

marcosoft41@gmail.com

 +255764292989