title: How to find second and third highest salary in mysql without using sub query
body: <p>I know this query but it is sub query can anyone explain me to confused i asked this quation in interview but i can't explain proper </p>
  
  <pre><code>select * from dept e where 2 =(select count(distinct salary) from dept where e.salary&lt;=salary)
  </code></pre>