Answer / mallikarjun

select max(sal) from emp
where sal < select max (sal)from emp






Mallikarjun

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))

Answer / v.karthikeyan

select * from emp
where &n-1=(select count(distinct(sal)) from emp b
where emp.sal<b.sal)

Answer / hiten

select max(sal) from emp where sal not in(select max(sal)
from emp);

Answer / prasant

SQL> select max(sal) from emp where sal<(select max(sal)
from emp);

MAX(SAL)
----------
3000

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);

Answer / karthikeyan

select max(sal) from emp
where sal <(select max (sal)from emp);

Answer / premsagar12

select max(sal) from emp where sal<(select max(sal) from emp);

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>

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

How to grant create session privilege to a user in oracle?

0 Answers  

find out the third highest salary?

92 Answers   CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon,

How to list all tables in your schema?

0 Answers  

How to divide query output into groups in oracle?

0 Answers  

What do you mean by group by clause?

0 Answers  

What is format trigger?

0 Answers  

14. Display the item_cost and then round it to the nearest hundred, ten, unit, tenth and hundredth

1 Answers   Wipro,

What is a nested table and how is it different from a normal table?

0 Answers  

Display the records between two range?

2 Answers  

What happens to the data files if a tablespace is dropped?

0 Answers  

how can we write trigger in trigger???????? can we write one trigger on two table???

2 Answers   Value Labs,

How to unlock the sample user account in oracle?

0 Answers