List unique departments of the EMP table

See more:

Oracle

Actually deptname is not available in emp table, that is the resion why i'm writing query by using join statement is it correct or not.....? Please replay me any bady knows.......?

QUERY:

SELECT DISTINCT(DNAME) FROM EMP INNER JOIN DEPT ON EMP.DEPTNO=DEPT.DEPTNO;