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

How to use attributes of the implicit cursor in oracle?

0 Answers  

How to use fetch statement in a loop?

0 Answers  

How to manage transaction isolation level?

0 Answers  

How index is implemented in oracle database?

0 Answers  

What is SQL Tuning Advisor in Oracle?

0 Answers   MCN Solutions,

how to hide the stored procedure inside a package

1 Answers  

i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?

2 Answers   Microsoft,

what is the exact diiference between DBMS and RDBMS

4 Answers   Tesco,

How to insert a new row into a table in oracle?

0 Answers  

Display those managers salary greater than the average salary of his employees?(Based on oracle standard Emp table)

6 Answers  

1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

0 Answers   TCS,

how can we store any pdf file in oracle

0 Answers