select () as

select (select distinct salary as  SecondHighestSalary  from employee order by salary desc limit 1,1) as SecondHighestSalary