Q. List the employee names and the name of their departments.


Consider  this table --

SALARYGRADE ( LOWSAL , HIGHSAL , GRADE )
DEPT(DEPTNO. , DEPTNAME , LOCATION)

You can understand by seeing this video ---



Answer :-

SELECT ENAME , DEPTNO FROM EMPL , DEPT
WHERE EMPL.DEPTNO = DEPT.DEPTNO;

Post a Comment

You can help us by Clicking on ads. ^_^
Please do not send spam comment : )

Previous Post Next Post