title: Can someone suggest innovative queries for selecting the 2nd highest salary from a table of employees?
body: <p>Can someone suggest innovative queries for selecting the 2nd highest salary, from a table "EMP" which consists of three "NOT NULL" fields, sal(salary), name, empno(employee number) ?</p>
  
  <p>I have one:</p>
  
  <pre><code>Select sal 
  from EMP A 
  where 1 = (select count(DISTINCT SAL) from EMP B whre A.sal &lt; B.sal);
  
  select DISTINCT sal 
  from emp a 
  where 1 = (select count(DISTINCT sal) from emp b where a.sal &lt; b.sal);
  </code></pre>