Write a query to get 2nd maximum salary in an employee table ?

Answer Posted / sandeep

select top(1) a.salary
from

(
select top(2)sal
from
employee
order by salary desc
)a
order by a.salary asc

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to load data files into tables with 'mysqlimport'? : Sql dba

528


who introduced sql?

572


What is a procedure in pl sql?

553


What is Materialized View? In What Scenario we Use Materialized View?

8541


What is scalar function in sql?

536






What is percent sign in sql?

725


what is a composite primary key ? : Sql dba

583


Which command is used to call a stored procedure?

505


Does google use sql?

518


How does pl sql work?

530


what tools available for managing mysql server? : Sql dba

535


What is rtm stands for?

588


how are mysql timestamps seen to a user? : Sql dba

566


What is the maximum size of sqlite database?

550


Is sql workbench free?

536