how to select second mauximum value in a given table under salary column
Answers were Sorted based on User's Feedback
Answer / jai
SELECT MAX(SALARY) FROM EMPLOYEE
WHERE SALARY NOT IN(SELECT MAX(SALARY) FROM EMPLOYEE)
Is This Answer Correct ? | 27 Yes | 2 No |
Answer / sonthosh
SELECT * FROM
(
SELECT
NAME
,SALARY
,RANK() OVER (order by salary desc) RANK
FROM EMPLOYEE)
WHERE RANK = 2
Is This Answer Correct ? | 7 Yes | 4 No |
Answer / utkal
Select distinct(E1.Salary) from EMPLOYEE E1 where 2 =
(Select Count(distinct(E2.Salary)) from Employe E2 where
E1.Salary <= E2.Salary).
Here n=2,
Similarily we can find the 5th highest salary etc...
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / u.radha
SELECT * FROM (SELECT ENAME,SAL,DENSE_RANK() OVER(ORDER BY SAL DESC) RN FROM EMP) WHERE RN = 2;
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / shri
select min(sal) from (select * from emp order by sal desc) where rownum<3
IN Informatica also use the query in source qualifier's
"sql override". which will reduce d no. of t/r in d mapping
Is This Answer Correct ? | 3 Yes | 3 No |
How to Remove the 3rd highest salary person record from table?
What are advantages fo Stored Procedures?
what is the difference between functional dependecy and multilevel dependency?
Explain oracle’s system global area (sga).
Explain the difference between a procedure and a function?
What are the ansi data types supported in oracle?
How to drop an existing table in oracle?
There are three tables : E : EID,ENAME D : DID,DNAME empdept : eid, did select the employees who doesn't belong to any dep
How to convert numbers to characters in oracle?
What is forall Statement ?
What is bulk load in oracle?
How do I escape a reserved word in oracle?