Answer / mihir nasikkar

Here n is 3


SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP n salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary

Answer / gayathri

if you compare the salary slip u can find

Answer / karunakar varma

select a,sal from (select dense_rank() over (order by sal
desc) a,sal from emp) where a=3

Answer / abbas

SELECT * FROM
(
SELECT EMPLOYEECODE, SAL, Rank() OVER (ORDER BY SAL DESC )
RANKNEW FROM EMPLOYEE)
WHERE RANKNEW = 3

Answer / mahesh

select * from emp where sal<(select max(sal) from emp
where sal<(select max(sal) from emp))

Answer / nirad

select Top 1 *
from ( select top 3 * from Customer order by salary desc )
tempt
order by salary asc


if you want third lowest just desc with asc and asc with
desc and even if you want 2 or other hight value just
change inner query value of 3

Answer / chinmaya

Select Top 1 Sal from (Select Top 3 Sal from emporder by
Sal desc) x order by Sal

Answer / vanaja

select * from emp5 where salary in(select min(salary) from
emp5 where salary in(select top 3 salary from emp5 order by
salary desc))

Answer / sam

Guys
See the correct answer.

select distinct sal from emp a where 4 =(select
count(distinct(sal)) from emp where a.sal <= sal)

Answer / ajit

SQL QUERIES FOR FINDING Nth HIGHEST SALARY

SELECT DISTINCT (a.salary) FROM EMPLOYEES A WHERE &N = (SELECT COUNT (DISTINCT (b.salary)) FROM EMPLOYEES B WHERE a.salary<=b.salary);

What is the usage of save points in oracle database?

0 Answers  

What is varray?

0 Answers  

hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

0 Answers  

difference between imlicit cursor and explicit cursor ?

5 Answers   Cap Gemini,

What does sharding mean?

0 Answers  

State all possible different index configurations a table can possibly have?

0 Answers  

How to define Data Block size ?

2 Answers  

HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.

0 Answers  

can any one help me with import/export options in oracle............

1 Answers  

What is Public Database Link ?

1 Answers  

How to retrieve values from data fields in record variables?

0 Answers  

if i am using dml statement in function. then i am writing select statement what was the output

2 Answers   MasterCard,