1.

Write a SQL statement (s) to list all employees in the following format:EMPLOYEEWORKS IN DEPARTMENWORKS IN DEPARTMEN7369-SMITHWORKS IN DEPARTMENT207300-SUDHIRWORKS IN DEPARTMENT207345-RAJWORKS IN DEPARTMENT107329-SMITHSWORKS IN DEPARTMENT307234-SANTOSHWORKS IN DEPARTMENT30

Answer»

SELECT ename,'WORKS IN DEPARTMENT', deptno FROM emp;



Discussion

No Comment Found

Related InterviewSolutions