How to find second and third highest salary in mysql without using sub query
<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>