Question

Write sql query of list the emps of deptno 30 or 10 joined in the year 1981;

Answer 1

SQL QUERY IS GIVEN BELOW


select *


from emp where job ='CLERK'



and deptno = 20; 36.




List the emps of Deptno 30 or 10



joined in the year 1981