Answer / shruti

select empno,sal from
(select empno,sal from emp order by sal desc)
where rownum<4

Answer / tathagoto

select min(sal) from (select sal from (select sal from
salary order by sal desc) where rownum <
4);

Answer / sathiskumar

select min(sal) from (select top 3 salary from employee);

Answer / av.anil

SELECT * FROM
(SELECT Ename,Sal,
DENSE_RANK()
OVER(ORDER BY Sal DESC) "D_RK"
FROM Emp)
WHERE D_RK = 3;

This query gives exact highest salary.

Answer / jagdish

select max(sal) from emp where sal!=(select max(sal) from
emp where sal!=(select max(sal) from emp))

Answer / vivek

SELECT v.Emp_Sal
FROM Employee_Test v
WHERE 3=
(
SELECT COUNT(DISTINCT z.Emp_Sal)
FROM Employee_Test z
WHERE v.Emp_Sal<=z.Emp_Sal
)

Answer / shibin k abraham

select * from emp where sal=(select a.sal from emp awhere 3=(select distinct(count(b.sal)) from emp b where a.sal<=b.sal))

Answer / priyanga.g

1) Select MAX(salary) from Programmer where salary not
in(select top 2 salary from Programmer order by salary desc)



2) Select max(salary) from programmer where salary<
(select MAX(salary) from Programmer where salary<(select
MAX(salary) from Programmer))


3) Select MAX(salary) from Programmer e where 2=(select
COUNT(*) from programmer b where b.salary>e.salary )

Answer / ratnakar

select max(sal) from emp a where 3=(select count(sal) from
emp b where b.sal >=a.sal;

Answer / sheik

select top 1 * from(select top 3 *from emp order by salary
desc)d order by salary asc

can we use out parameter in a function?Give an example.

4 Answers   Logica CMG, TCS,

Is oracel sql developer written in java?

0 Answers  

What is the difference between DELETE, TRUNCATE, and DROP?

3 Answers  

there are .......different types of serializability

1 Answers   Wipro,

display null value rows with out using null function?

8 Answers   Infosys,

What is input buffer in sql*plus?

0 Answers  

how to run 'mysql' commands from a batch file? : Sql dba

0 Answers  

What are different types of functions in sql?

0 Answers  

how to drop an existing view in mysql? : Sql dba

0 Answers  

How do I get sql certification?

0 Answers  

if we give update table_name set column_name= default. what will happen? its given in pl sql block.what will hapen?

5 Answers   iFlex,

Which is faster joins or subqueries?

0 Answers