title: Find first highest salary employee under manager
body: <p>In the employee table data is stored as below</p>
  
  <pre><code>Empno ename  salary manager
  
  1     prasad 100    4
  2     durga  200    4
  3     ggggg  200    4
  4     jjjjj  300    6
  5     kkkkk  600    6
  6     dddddd 700    7
  </code></pre>
  
  <p>I need to find out the first highest salary employee under manager.</p>
  
  <p>my sql code and output:</p>
  
  <pre><code>select * from employee where salary in
           (select max(salary) from employee group by manager);
  </code></pre>
  
  <p>output:</p>
  
  <pre><code>Empno ename  salary manager
  
  2     durga  200    4
  3     ggggg  200    4
  5     kkkkk  600    6
  6     dddddd 700    7
  </code></pre>
  
  <p>Expecting output should be:</p>
  
  <pre><code>2     durga  200    4
  5     kkkkk  600    6
  6     dddddd 700    7
  </code></pre>
  
  <p>because salary '200' displaying two times for two employees. My requirement is that display first highest salary employee only under manager.</p>
  
  <p>Can anyone suggest sql query for my expecting output. Thanks in advance</p>