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;

How do I start sql profiler?

0 Answers  

What is the use of & in pl sql?

0 Answers  

How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

0 Answers  

How many types of primary keys are there?

0 Answers  

What is pragma exception and how, when, where us

5 Answers  

What is a dynamic query?

0 Answers  

what are all types of user defined functions? : Sql dba

0 Answers  

How can we find duplicate records in a table?

0 Answers  

display null value rows with out using null function?

8 Answers   Infosys,

Explain what is a subquery ?

0 Answers  

what's the difference between a primary key and a unique key? : Sql dba

0 Answers  

Write an sql query to select all records from the table?

0 Answers