title: List of employees who are not managers
body: <p>I would like to pull list of employees who are not managers...</p>
  
  <p>Have a look at below two queries post if you have a better query...</p>
  
  <p><strong>Query 1:</strong></p>
  
  <pre><code>SELECT Empno, Ename, Job, Sal
  FROM Emp
  WHERE Empno NOT IN (SELECT NVL(MGR,0) FROM Emp)
  </code></pre>
  
  <p><strong>Query 2:</strong></p>
  
  <pre><code>SELECT Empno, Ename, Job, Sal
  FROM Emp
  WHERE Empno NOT IN (SELECT DISTINCT MGR FROM Emp WHERE MGR IS NOT NULL)
  </code></pre>