Display employee number,name and location of the department in which he is working.

Jitendrasoft09
Posted by Jitendrasoft09 under Oracle category on | Points: 40 | Views : 724
select empno,ename,loc,dname from emp,dept where
emp.deptno=dept.deptno;

Comments or Responses

Login to post response