find out the second highest salary?
- 55 Answers
- 80993 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 concatenate two text values in oracle?
What is the data type of dual table?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
Explain oracle 12c new features for developers?
Design database draw er diagram for a certain scenario ?
0 Answers Keane India Ltd, TATA,
How to delete a column in an existing table in oracle?
What is the difference between a hot backup and a cold backup in oracle?
Is java required for oracle client?
How to delete all rows a table in oracle?
wirte the syntax of update query?
What is an Oracle sequence?
can u call user defined functions in select statements
Oracle General 
