SECOND HEIGHEST SAL IN SQL

select name,sal
from(
            select name,sal,ROW_NUMBER() over (order by sal desc) as rowid from sal
      )A
where rowid=2second heighest sal in sql