Saved Bookmarks
| 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; |
|