Write a query to get 2nd maximum salary in an employee table ?
Answers were Sorted based on User's Feedback
Answer / jebitha
select max(sal) from emp where sal<>(select max(sal) from
emp);
Is This Answer Correct ? | 7 Yes | 9 No |
Answer / babbu
it's easy with self join:
select max(sal) from emp e1,emp e2 where e1.sal < e2.sal
Is This Answer Correct ? | 0 Yes | 2 No |
Answer / lakshminarayana reddy
select rownum,empno,ename,job,sal from emp(select
rownum,empno,ename,job,sal from emp order by sal desc) grop
by rownum,empno,ename,job,sal having rownum=2;
Is This Answer Correct ? | 7 Yes | 10 No |
Answer / varun
select max(sal) from emp ((select sal from emp)-(select max
(sal) from emp))
Is This Answer Correct ? | 5 Yes | 8 No |
Answer / naresh kumar kalangi
select top 1 * from (select top 2 * from emp order by sal
desc)s order by sal
Is This Answer Correct ? | 5 Yes | 8 No |
Answer / surajit pathak
select * from emp e1
where 2>(select count(1) from emp e2
where e2.sal>e1.sal)
order by sal desc
Is This Answer Correct ? | 1 Yes | 4 No |
Answer / satya_k21
Hi,
Select * from emp e where 2>= (select count(sal) from
emp e where sal>=e.sal) order by desc.
Let me know if it is wrong..
Regards,
Satya.K
Is This Answer Correct ? | 11 Yes | 16 No |
Answer / rajesh.m
Crete Table Curtest(Emp char(40),salary money)
------------------------------------------------
Select Min(Salary) from Curtest where Salary
in (select Top 2 Salary from Curtest)
--------------------------------------------------
Is This Answer Correct ? | 21 Yes | 33 No |
Answer / varun
select sal from emp where rownum=2 order by sal desc;
Is This Answer Correct ? | 6 Yes | 19 No |
Can we use having without group by in sql?
Is null operator in sql?
What is out parameter used for eventhough return statement can also be used in pl/sql?
What do you know by pl/sql cursors?
Can sql developer connect to db2?
How do I make sql search faster?
Explain spool.
What is union and union all keyword in sql and what are their differences?
suppose we have a table in which 200 rows. i want to find 101 row ? what the query.... and how we find 4th and 5th highest salary and 1 to 10 highest salary
What is a mutating table and a constraining table?
What is a table?
how to create a primary key with out creating an index?