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
how to load data files into tables with 'mysqlimport'? : Sql dba
who introduced sql?
What is a procedure in pl sql?
What is Materialized View? In What Scenario we Use Materialized View?
What is scalar function in sql?
What is percent sign in sql?
what is a composite primary key ? : Sql dba
Which command is used to call a stored procedure?
Does google use sql?
How does pl sql work?
what tools available for managing mysql server? : Sql dba
What is rtm stands for?
how are mysql timestamps seen to a user? : Sql dba
What is the maximum size of sqlite database?
Is sql workbench free?