How to find only %th Highest Sal

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

Question Posted / ashok chowdary

6 Answers
12253 Views
Infogain, Symphony, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to find only %th Highest Sal..

Answer / sujit pingale

Ans: select distinct(a.salary) from customers a where &n =
(select count(distinct(b.salary)) from customers b where
a.salary <= b.salary);

It will ask you to enter number in input box which salary
you want to see

Is This Answer Correct ?

3 Yes

0 No

How to find only %th Highest Sal..

Answer / sujitpingale

Ans: select distinct(a.salary) from customers a where &n =
(select count(distinct(b.salary)) from customers b where
a.salary <= b.salary);

Enter value in inputbox. If you enter 1 then it will give
highest salary

Is This Answer Correct ?

2 Yes

0 No

How to find only %th Highest Sal..

Answer / ajit

select e.*, rn
from ( select empno, ename, sal, deptno, dense_rank() over ( order by sal desc ) rn
from emp) e
where rn = & rn;

Is This Answer Correct ?

2 Yes

0 No

How to find only %th Highest Sal..

Answer / abhishekjaiswal

SELECT A.FIRST_NAME,
A.SALARY
FROM EMPLOYEES A
WHERE 3 = ( SELECT COUNT(*) -- Replace 3 with any value of (N - 1)
FROM EMPLOYEES B
WHERE B.SALARY > A.SALARY)

Is This Answer Correct ?

1 Yes

0 No

How to find only %th Highest Sal..

Answer / pavan

select e.* from emp e where &n=(select count(distinct e1.sal)from emp e1 where e.sal>e1.sal)

Is This Answer Correct ?

0 Yes

0 No

How to find only %th Highest Sal..

Answer / ajit

select *
from emp
where sal = ( select max(sal)
from emp
where level = &n
connect by prior sal > sal
group by level);

Is This Answer Correct ?

0 Yes

0 No

Post New Answer