There is a 5000 EMP in company.how we find out the 5th highest getting salary

Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
Suggest New Category

There is a 5000 EMP in company.how we find out the 5th
highest getting salary employee outof 5000 employes........

Question Posted / deepak_mallela407

10 Answers
15155 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 ..

Answer / nagireddy

select max(sal) from emp a where 5=(select count(distinct sal)
from emp b where a.sal<=b.sal);

Is This Answer Correct ?

13 Yes

3 No

There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 ..

Answer / kasyapa

select * from emp A where 4 = (select count(*) from emp B
where A.sal<B.sal)

Is This Answer Correct ?

6 Yes

2 No

There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 ..

Answer / satish kalynm

SELECT * FROM T999 WHERE SAL<(SELECT MAX(SAL) FROM T999
WHERE SAL<(SELECT MAX(SAL) FROM T999 WHERE SAL<(SELECT
MAX(SAL) FROM T999 WHERE SAL<(SELECT MAX(SAL) FROM T999))));

Is This Answer Correct ?

5 Yes

2 No

There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 ..

Answer / rajib

select max(salary) from staff where salary not in(select
salary from staff order by salary desc fetch first 4 rows
only)

Is This Answer Correct ?

3 Yes

0 No

There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 ..

Answer / payel

SELECT * FROM STAFF AA
WHERE 5 = (SELECT COUNT (SALARY) FROM STAFF WHERE SALARY
<= AA.SALARY );

Is This Answer Correct ?

3 Yes

1 No

There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 ..

Answer / ashok

in above answers what is a.sal and b.sal please explain me

Is This Answer Correct ?

0 Yes

0 No

There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 ..

Answer / abhusha

SELECT SAL FROM EMP A
WHERE 5 = (SELECT COUNT(*) FROM EMP B
WHERE B.SAL >= A.SAL)

Is This Answer Correct ?

0 Yes

0 No

There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 ..

Answer / sachin

SELECT MAX(SALARY) FROM EMP WHERE SALARY <
(SELECT MAX(SALARY) FROM EMP WHERE SALARY <
(SELECT MAX(SALARY) FROM EMP WHERE SALARY <
(SELECT MAX(SALARY) FROM EMP WHERE SALARY <
(SELECT MAX(SALARY) FROM EMP WHERE SALARY ))))

Is This Answer Correct ?

0 Yes

1 No

There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 ..

Answer / pavan

try this one....

select * from emp where emp_Id = (select emp_Id from emp
order by sal)
and count(*) < 6;

Is This Answer Correct ?

0 Yes

5 No

There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 ..

Answer / udhay

SELECT MAX(salary)
FROM employees
WHERE salary
NOT IN (SELECT TOP 4 salary FROM employees ORDER BY salary
DESC)

Is This Answer Correct ?

1 Yes

7 No

Post New Answer