write a query to find the third maximum salary of a
employee.(table:employ col name:salary)
Answers were Sorted based on User's Feedback
Answer / ravindra
select max(sal) from emp where level=3 connect by prior sal>sal;
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / shrikant
SELECT MIN(sal) FROM emp WHERE
sal IN (SELECT distinct TOP 3 sal FROM emp ORDER BY sal
DESC)
select max(sal) from emp where sal<(select max(sal) from emp
where sal<( select max(sal) from emp));
select * from emp e
where 3 = (select count(sal) from emp
where e.sal < sal);
Select * from EMP_USER A where n-1 = (select count
(distinct (sal)) from EMP_USER B where A.sal<B.sal)
Is This Answer Correct ? | 4 Yes | 2 No |
Answer / saiprasanna
select max(salary) from employ
where salary=(select max(salary) from employ where salary
<(select max(salary) from employ));
Is This Answer Correct ? | 5 Yes | 3 No |
Answer / jithendranath.g
SELECT Z2.SAL FROM EMP Z1,EMP Z2
WHERE
Z2.SAL <=Z1.SAL
GROUP BY Z2.SAL
HAVING COUNT(Z2.SAL)=3
Is This Answer Correct ? | 3 Yes | 2 No |
select e.ename,a.sal from (select sal, rownum rnum ,rowid
rid from (select * from emp order by sal desc)) a , emp e
where a.rid= e.rowid
and a.rnum = 3
Is This Answer Correct ? | 1 Yes | 0 No |
select ename,sal from (select rownum rnum ,rowid rid from
emp order by sal desc) a , emp e
where a.rnum = 4
and a.rid= e.rowid
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / suresh
Select emp.*,dense_rank()over(order by sal desc) rn from emp
where rn=3;
Is This Answer Correct ? | 1 Yes | 3 No |
How to find locks exists in a table or not?
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
How many segment are present in Oracle Manufacturing
Explain materialized views and how they are used.
IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
What is database schema?
Differentiate between writeoff and receipt writeoff. : oracle accounts receivable
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
Explain the process of recievables in oracle financials. : oracle accounts receivable
Differentiate between transaction type and transaction source? : oracle accounts receivable
How can you gather statistics on a table?
What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?