Find the location of the sales department using SQL. EMP Table: Field ------------------------------- -------- ------------------------------------------------------------------------ EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO DEPT Table: Field DEPTNO DNAME LOC
Find the location of the sales department using SQL.
EMP Table:
Field
------------------------------- -------- ------------------------------------------------------------------------
EMPNO
ENAME
JOB
MGR
HIREDATE
SAL
COMM
DEPTNO
DEPT Table:
Field
DEPTNO
DNAME
LOC
Here, you need to find location of sales department.
You have one table called 'DEPT' in which there are columns like DNAME and LOC.
DNAME column will contain department names and LOC column will contain location.
So by using these columns, you can find location of sales department.
You need to use 'where' clause on 'DNAME' column to find location.
Step by step
Solved in 2 steps
