Answer / guest

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

Answer / tanuj tewari

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

Answer / sunil

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

or

select sal from(select sal,dense_rank() over(order by sal)
as rnk from table_name) where rnk=2;

Answer / abhijit

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

or

select sal from(select sal,dense_rank() over(order by sal
desc)
as rnk from table_name) where rnk=2;

Answer / ranjini

select max(salary) from employee not exists (select
max(salary)from employee)

Answer / arpit sachan

select min(Emp_Sal)from Employee_Test where Emp_sal in(select distinct top(2) Emp_Sal from Employee_Test order by Emp_Sal desc)

Answer / ranjith

select salary from table order by salaray desc limit 1,1

Answer / kuldeep singh

select max(sal) from emp where sal not in (select top2 sal from emp order by sal desc)

Answer / sephali

select sal, rownum
from (select sal from table
order by sal desc)
where rownum=2

Answer / 9896012055

what will be the answer for this question

Explain a private synonyms?

0 Answers  

What is clustered table in Oracle?

0 Answers   MCN Solutions,

Explain database link?

0 Answers  

How to bring a tablespace offline?

0 Answers  

how to find out largest value in a table

2 Answers  

How are extents allocated to a segment?

0 Answers  

How do I use os authentication with weblogic jdriver for oracle and connection pools?

0 Answers  

What is a Shared SQL pool ?

2 Answers  

Point out the difference between user tables and data dictionary?

0 Answers  

Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

0 Answers  

What are triggers?Where are they used?

3 Answers  

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

6 Answers   Sapient,