Write a query to get 2nd maximum salary in an employee table ?
Answers were Sorted based on User's Feedback
Answer / priya
select rownum,empno,sal from (select
rownum,empno,sal from emp order by sal desc) group
by rownum,empno,sal having rownum=2;
This will clearly work.............
Is This Answer Correct ? | 6 Yes | 3 No |
Answer / nitika
SELECT MAX(SAL) FROM EMPLOYEE WHERE SAL<(SELECT MAX(SAL)
FROM EMPLOYEE);
Is This Answer Correct ? | 4 Yes | 1 No |
Answer / hasnain hameed
select max(salary)
from emp
where salary < (select max(salary) from emp)
order by salary desc;
i think this is correct answer all of above because it take
less time to execute. retrive the answer quickly.
Is This Answer Correct ? | 6 Yes | 4 No |
Answer / kirti
Very simple answer: Arrange the top two salaries in
decending order. Select the mininum salary.
Select min(salary) from Employee where salary in(select top
2 salary from employee order by salary desc)
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / anupam274
use AdventureWorks
select * from HumanResources.EmployeePayHistory e where
2 = (select count(distinct Rate) from
HumanResources.EmployeePayHistory where e.Rate<=Rate)
select * from HumanResources.EmployeePayHistory e where
4 >(select count(distinct Rate) from
HumanResources.EmployeePayHistory where e.Rate<=Rate)
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / malli
select max(sal) from emp where sal<(select max(sal) from emp);
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / gaurav mishra
The answer query is......
Select max(sal) from emp a where (&N-1) in(select count
(distinct(b.sal)) from emp b where a.sal<b.sal);
Is This Answer Correct ? | 5 Yes | 4 No |
Answer / mallikarjuna
select max(sal) from emp where sal<(select max(sal) from emp);
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sandeep
select top(1) a.name
from
(
select top(2) name,salary
from
employee
order by salary desc
)a
order by a.salary asc
Is This Answer Correct ? | 1 Yes | 0 No |
What is a Procedure ?
how a reference cursor works?what all adnvantages are gained with it..specify the situation?
What does <> sql mean?
What are the types of dbms?
What is oracle pl sql developer?
what is cursor. write example of it. What are the attributes of cursor.
what is sql and plsql
What is sql in java?
What program will open a mdb file?
How to add a column ‘salary’ to a table employee_details?
Which type of cursor is used to execute the dml statement?
What is a full join?