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 create an initialization parameter file?

0 Answers  

why you need store procedure ? where do we use it in a Java project? can you get the code for as store procedure using in Java?

1 Answers   Goldman Sachs,

I have created one package with out procedures in package specification and in package body i have used 2 procedures. is it compile????

1 Answers  

How to sort the query output in oracle?

0 Answers  

I have table-A(1,2,3)& table-B(3,4,5).what is the different b/w below questions? A union all B? B union all A?

2 Answers   Zensar,

What is memory advisor in Oracle?

0 Answers   MCN Solutions,

Can we create more than one constraint to column ?

6 Answers  

what r tyhe major differences between oracle 9i & 10g?

6 Answers  

Is postgres faster than oracle?

0 Answers  

Define oracle database

0 Answers  

What is a Synonym ?

3 Answers  

The join defined by the default data link is an outer join yes or no ?

1 Answers   Oracle,