find out the second highest salary?
Answers were Sorted based on User's Feedback
Answer / nusrath sultana
select * from emp
where &n=(select count(distinct(sal)) from emp b
where emp.sal<=b.sal)
Is This Answer Correct ? | 1 Yes | 1 No |
select sal from(select sal,rank() over(order by sal desc)
rnk from emp) e
where e.rnk=2;
(OR)
select rownum,sal from emp group by sal,rownum
having rownum=2;
(OR)
select rn,sal from( select rownum rn,sal from emp group by
sal,rownum order by sal desc)
where rn=2;
Is This Answer Correct ? | 3 Yes | 3 No |
Answer / aravind
select * from empdetails where sal=(select max(sal) from
empdetails where sal<(select max(sal)from empdetails));
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / anand
SELECT SALARY FROM (SELECT SALARY FROM emp WHERE ROWNUM < 3
ORDER
BY salary) WHERE ROWNUM < 2
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sikindar
SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal)
Is This Answer Correct ? | 0 Yes | 0 No |
select max(salary) from employee where
salary<(select max(salary) from employee)
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / raunaq
to all the people who are using rownum in their queries...
This query will not work if you have more than 1 person
having the second highest salary
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / akash
select emp_id,sal from ( select emp_id,sal from emp where
sal < ( select max(sal) from emp) order by sal desc ) where
rownum < 2;
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nagaraju
SELECT LEVEL,MAX(SAL)
FROM EMP
WHERE LEVEL IN(2,3)
CONNECT BY PRIOR SAL>SAL
GROUP BY LEVEL;
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / madan kumar
select *from (select empno,deptno,min(sal) from emp
group by empno,deptno,sal
order by sal desc)
where rownum<=1
Is This Answer Correct ? | 0 Yes | 0 No |
How to create a new user account in oracle?
How do I learn what codesets are available in oracle?
How do I connect to oracle database?
How do I start tns listener?
What are the attributes of the cursor?
What happens if you set the sga too low in oracle?
What is varray?
What are the database administrators utilities available?
Can you tell me how to add new column in existing views?how?How is possible?
i have a table and it has constraints and i want to get "ALTER TABLE table_name ADD CONSTRAINT constraint_name constraint type" this code must be in string type please help me if you want, i can give more explainings
Design database draw er diagram for a certain scenario ?
0 Answers Keane India Ltd, TATA,
What is the data pump import utility?