Answer / krishna kishore

select top 1 salary from emp where salary in
(select top 2 salary from emp order by salary desc)
order by salary

Answer / kiran

select max(sal) from emp where sal in(select sal from emp
where sal<>(select max(sal) from emp))

/

Answer / ramcharan tej

select max(emp-sal) from emp
where emp-sal <(select max(emp-sal) from emp).

Answer / anurag kumar rai

select max(sal) from employee where sal<(select max(sal) from employee)

Answer / sachin verma

select sal from emp
where rownum=2
order sal by Desc

Answer / anil maurya

select top 1 rate from HumanResources.EmployeePayHistory
where rate<(select MAX(rate) as R from HumanResources.EmployeePayHistory)
order by rAte Desc

Answer / surendra sharma

select min(sal) from table_name where sal in

(SELECT top 2 sal FROM table_name order by sal desc)

Answer / yash goyal

Select Distinct salary
from employees e
where &no-1=(select count(distinct salary )
from employees
where E.salary < salary);

Answer / bharat g

select * from (select ename,sal,dense_rank() over (order by sal desc) ranking from emp) where ranking=2;

Answer / vinay

select max(sal) from emp where rownum = 2;

what is a materialized view? : Sql dba

0 Answers  

What operators deal with null?

0 Answers  

What is the difference between the conventional and direct path loads? : aql loader

0 Answers  

what are the different functions in sorting an array? : Sql dba

0 Answers  

What is the difference between SQL and PLSQL

7 Answers   IBM,

How to execute multiple sql statements in a single annonymous block irrespective of the sql statement result?

2 Answers  

What is pragma in sql?

0 Answers  

Explain dml and ddl?

0 Answers  

What is oracle ? why we should go for oracle database instead of diffrent databases available in the industry.

5 Answers   Polaris,

How would you reference column values before and after you have inserted and deleted triggers?

0 Answers  

What is parameter substitution in sql?

0 Answers  

What is percent sign in sql?

0 Answers