Querying for the second largest salary

Question

How would I go about querying for the second largest salary from all employees in my Employee table?

Answer 1

general SQL query should be as follows:

select
   sal 
from
   emp a 
where
   N = (
      select
         count(distinct sal) 
      from
         emp b 
      where
         a.sal <= b.sal
   )
where
   N = any value