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

what is view?

7 Answers   Accenture,

how to see the data (in unix) using dataset in datastage?

1 Answers   iGate,

9)When information has to be stored w.r.t employees and their respective departments, which of the following is the Correct formulation of entries? A)Employee and department would together be represented as an entity. B)This is too less information to decide on entities. C)An employee would be one entity and a department would be another. D)Such a scenario cannot be modelled in RDBMS

2 Answers   Mind Tree,

What are joins, explain all types of joins?

0 Answers   Bravura Solutions,

What happens to the current transaction if the session is killed?

0 Answers  

How to create a temporary table in oracle?

0 Answers  

Can group functions be mixed with non-group selection fields?

0 Answers  

Can we commit inside a function in oracle?

0 Answers  

What are the different editions of oracle?

0 Answers  

What is a Tablespace?

5 Answers  

what is IDE,DMV in sql server?

0 Answers  

Is java required for oracle client?

0 Answers