Write a query to get 2nd maximum salary in an employee table ?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / mark berlin.
REM solution #1:
select * from(
select distinct nvl(salary,-1) as sal
from employees
where nvl(salary,-1) < (select max(nvl(salary,-1)) from
employees)
order by nvl(salary,-1) desc)
where rownum=1;
REM Solution #2
select * from (
select distinct salary from employees
order by salary
desc
)
where rownum < 3
minus
select * from (
select distinct salary from employees
order by salary
desc
)
where rownum =1;
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sushant hole
select max(salary) from employees where salary<(select max(salary) from
employees);
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / boby
select max(MAXI) from
(SELECT max(slno) AS MAXI FROM EMPLOYEE WHERE slno not IN(SELECT max(slno) FROM EMPLOYEE )
GROUP BY slno)a
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / neha singh
select min(sal)
from
(select sal from
(select sal from emp
order by sal desc)
where rownum<=2)
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / baburav zore
select max(sal) from employee where sal<(select sal from employee);
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / akshay
Select ename, eno, sal, rownum
from (select ename, eno, sal from emp order by sal desc)
where rownum = 2;
Is This Answer Correct ? | 7 Yes | 7 No |
Answer / ahmad
Select Max(VacationHours) "MVacHrs"
from HumanResourcesEmployee
where VacationHours not in (Select Max(VacationHours)
from HumanResourcesEmployee)
Is This Answer Correct ? | 2 Yes | 2 No |
Answer / google
Select min(sal) from emp where sal in (
select top 3 sal from emp
order by sal desc )
Is This Answer Correct ? | 0 Yes | 0 No |
What is pls integer?
Can we use loop in sql?
how to calculate expressions with sql statements? : Sql dba
we have a package and we have grants to execute that package inside of that we have table, here we don't have privileges to this table? whether this package will execute or not?
Authentication mechanisms in Sql Server ?
how many sql ddl commands are supported by 'mysql'? : Sql dba
What are the datatypes a available in PL/SQL ?
how to use in conditions? : Sql dba
What are sql injection vulnerabilities?
How will you select unique values from a list of records?
Which table is left in left join?
What is the Diff b/w Constraints and Trigeer