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

After using set unused can we enable the column again to use? Please give me some answers....

1 Answers   Maveric,

Explain oracle 12c new features for developers?

0 Answers  

how to we delete a row using varray

3 Answers   CTC,

How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

1 Answers  

Why does oracle 9i treat an empty string as null?

0 Answers  

Draw E-R diagram for many to many relationship ?

0 Answers   Keane India Ltd,

Is primary key = unique key,not null? If yes,please explain IF No,please explain

8 Answers   Genpact,

how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

0 Answers  

How can you use check constraints for self referential integrity?

0 Answers  

if you ctreate table identity

0 Answers  

Explain alias?

0 Answers  

What is a user role in oracle?

0 Answers