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

1. How actually index will work ? 2. Why do people prefer mostly bitmap index and btree index in datawarehouse ? 3. If I use the column in aggrigate functions like max,min,count and avg and if I have a index created on that column, will it increases the performance ?

1 Answers   IBM,

What is Trigger in Oracle?

1 Answers   MCN Solutions,

What is the quickest way to fetch the data from a table?

1 Answers  

How to see the table columns used in an index?

1 Answers  

How will you write a query to get a 5th rank student from a table student_report?

1 Answers  

When do we use group by clause in a sql query?

1 Answers  

is there a tool to trace queries, like profiler for sql server?

1 Answers  

Explain an index segment?

1 Answers  

What are the differences between blob and clob in oracle?

1 Answers  

What is the difference between normal and corelated subqueries?

2 Answers  

What is the difference between view and materialized view in Oracle?

1 Answers   MCN Solutions,

What is SYSTEM tablespace and When is it Created?

2 Answers