Saved Bookmarks
| 1. |
Write a suitable SQL statement to display ALL employees working in New York in the following format :EmpName Salary Location |
|
Answer» SELECT A.empname, A.salary,B.location FROM emp A INNER JOIN dept B on A.deptno=B.deptno WHERE location LIKE 'NewYork'; |
|