title: To take out those dept who has no employees assigned to it
body: <p>I want to write an sql query , and want to get the dept name from DEPT table who has no employees assigned in EMP table.</p>
  
  <p>Table Structure:</p>
  
  <pre><code>EMP
  EMPNO   ENAME    DEPTNO
  
  DEPT
  DEPTNO   DNAME
  </code></pre>
  
  <p>So I like to know those DEPT who has no employees association.</p>