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

Explain oracle data types with examples?

0 Answers  

Explain overloading. Can functions be overloaded?

0 Answers  

Can we create database in oracle using command line ?

0 Answers   MCN Solutions,

How to find the duplicate rows count from employees table in oracle?

0 Answers  

How can return max date row A b c d e 1 2 1-mar-09 5 10 1 2 10-mar-09 5 10 Only using oracle predefined function. Not user defined. Output:-- A b c d e 1 2 10-mar-09 5 10

2 Answers  

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

0 Answers  

Explain a private synonyms?

0 Answers  

Explain the family trees and connection by clause

0 Answers  

What is a cursor and what are the steps need to be taken?

0 Answers  

how to select second mauximum value in a given table under salary column

6 Answers   Sapient,

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

0 Answers  

How to loop through a cursor variable?

0 Answers