Interested to Buy Any Domain ? << Click Here >> for more details...
find out the second highest salary?
- 55 Answers
- 87747 Views
- Cognizant, Nucsoft, Oracle, TCS, Wondersoft, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mallikarjun
select max(sal) from emp
where sal < select max (sal)from emp
Mallikarjun
| Is This Answer Correct ? | 216 Yes | 86 No |
Answer / ananth
this is for 2nd highest sal in sql server database
select * from emp where sal=(select max(sal) from emp where
sal<(select max(sal) from emp))
| Is This Answer Correct ? | 119 Yes | 13 No |
Answer / v.karthikeyan
select * from emp
where &n-1=(select count(distinct(sal)) from emp b
where emp.sal<b.sal)
| Is This Answer Correct ? | 62 Yes | 30 No |
Answer / hiten
select max(sal) from emp where sal not in(select max(sal)
from emp);
| Is This Answer Correct ? | 25 Yes | 2 No |
Answer / prasant
SQL> select max(sal) from emp where sal<(select max(sal)
from emp);
MAX(SAL)
----------
3000
| Is This Answer Correct ? | 22 Yes | 3 No |
Answer / abhijit ramakant parb
select min(a.sal) from(select distinct d.sal from emp d
order by sal desc) a where rownum<=2;
To retrieve all columns
select * from emp where sal=(select min(a.sal) from(select
distinct d.sal from emp d order by sal desc) a where
rownum<=2);
| Is This Answer Correct ? | 12 Yes | 6 No |
Answer / karthikeyan
select max(sal) from emp
where sal <(select max (sal)from emp);
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / premsagar12
select max(sal) from emp where sal<(select max(sal) from emp);
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / peter
SQL> select max(sal) sal
2 from (select sal,
3 dense_rank() over
4 (order by sal desc) rnk
5 from emp )
6 where rnk = 2;
SAL
----------
3000
SQL>
| Is This Answer Correct ? | 14 Yes | 9 No |
Answer / janmejaya
select top(1) * from employee where salary in (select
distinct top(2) salary from employee order by salary desc)
order by Salary
Above query is dynamic, if u want 3rd highest then just
change 2 to 3 , Please Try It
| Is This Answer Correct ? | 4 Yes | 0 No |
How to create a table index in oracle?
Explain the importance of .pll extension in oracle?
What is the difference between substr & instr functions?
How to use regular expression in pattern match conditions in oracle?
Explain oracle instance.
Which is better Oracle or MS SQL? Why?
What is the difference between SQL, DDL, and DML?
7 Answers BeBo Technologies, Wipro,
How do I learn what codesets are available in oracle?
How much memory your 10g xe server is using?
What is a dynamic performance view in oracle?
How to view all columns in an existing table?
What are the differences between interval year to month and interval day to second?
Oracle General 
