Interested to Buy Any Domain ? << Click Here >> for more details...
find out the second highest salary?
- 55 Answers
- 89799 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 |
what is the scenario where you take the database to NoArchivelog mode?
Explain a data segment?
What is system global area (sga) in oracle?
what r routers?
various types of hints and their usage
How to create a server parameter file?
What is hash cluster in oracle?
What are Clusters ?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
how many triggers we can create on a table
11 Answers G2 Technology, TCS,
Explain the use of rows option in exp command.
Point the difference between translate and replace?
Oracle General 
