Interested to Buy Any Domain ? << Click Here >> for more details...
find out the second highest salary?
- 55 Answers
- 89901 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 |
Can anyone give me information about oracle certification
what are the diffeenes between oracle 9i,oracle 10g
What is the difference between PFILE and SPFILE in Oracle?
Give the Types of modules in a form?
What are the ansi data types supported in oracle?
What is a sub query? Describe its types?
The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ================ 1 NULL 2 NULL 3 4 NULL 5 6 7 NULL NULL O/P C = 2 4 6
What are the uses of a database trigger?
How to view the dropped tables in your recycle bin?
How to call a trigger inside a stored procedure?Give an example.
How do I know if oracle is installed on windows?
what is null value?
Oracle General 
