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';



Discussion

No Comment Found

Related InterviewSolutions