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 acid property in a database?

0 Answers  

How well can multiple sessions access the same data simultaneously ?

1 Answers   Oracle,

how to find the second highest salary from emp table?

211 Answers   CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar,

What are the datatypes a available in PL/SQL ?

2 Answers  

What is t sql used for?

0 Answers  

what is the differnce between procedure and function? in both dml operations can work and in procedure through out parameter you can return value ,then what is the differce?

3 Answers   3i Infotech,

What is the diff between Truncate table / delete <table name> purge

3 Answers   TCS,

What are the types of views in sql?

0 Answers  

does sql support programming? : Sql dba

0 Answers  

Delete duplicate records in the emp table.

6 Answers   Oracle,

Types of cursor locks and explanation each of them ?

3 Answers   DELL, HP Finsoft,

How do you add a column to a table?

0 Answers