There is a 5000 EMP in company.how we find out the 5th
highest getting salary employee outof 5000 employes........
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
Answer / ashok
in above answers what is a.sal and b.sal please explain me
Is This Answer Correct ? | 0 Yes | 0 No |
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 |
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 |
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 |
What is a db2 table?
how to resolve -805 . how to see dbrm and package not found
a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.
What is buffer pool in the db2 database?
What is the picture clause of null indicator variable?
Explain package in db2 and its advantages?
Which command is used to remove all rows from a table?
What is sqlcode -811?
7 Answers Accenture, CTS, TCS,
is there any restrictions for unions ?
How does one remove entries from the SCT02 table?
What r the comman abends in db2, jcl and cobol???????
what is datacom db?