title: Find second highest salary from a table with three coloumns Id, name, salary
body: <p>How to find second highest salary from a table with three columns and these are <strong><code>id</code></strong>, <strong><code>name</code></strong>, <strong><code>salary</code></strong> but using in <strong><code>SELF JOIN</code></strong>.Got answer via <strong><code>nested query</code></strong>. but, I want to know how can we frame using <strong><code>SELF JOIN</code></strong></p>