INTERVIEW QUESTIONS ORACLE GENERAL ORACLE DETAILS

Question: How can I get 5th highest sal. from employee tab?

Answer: Select max(sal) from emp where sal<(select max(sal) from emp where sal<(select max (sal) from emp where sal<(select max (sal) from emp where sal<(select max(sal) from emp))));

Select max(sal) from emp where sal<(select max(sal) from emp where sal<(select max (sal) from emp where sal<(select max (sal) from emp where sal<(select max(sal) from emp)))); Source: CoolInterview.com

SELECT TOP 1 salary
FROM (SELECT DISTINCT TOP 5 salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary Source: CoolInterview.com

FOR nth HIGHEST ENTRY:-
SELECT MAX(SALARY)
FROM employee e1
WHERE &N = ( SELECT COUNT(DISTINCT(SALARY))
FROM employee e2
WHERE e1.SALARY <= e2.SALARY);

Put the value for the n & you can find any no. of highest salary. Source: CoolInterview.com

select rownum,employee_id,salary
from (select employee_id,salary
from employees
order by salary desc)
where rownum<=5;
Source: CoolInterview.com

SELECT COLUMNNAME FROM TABLENAME T1 WHERE N=(SELECT COUNT(DISTINCT(COLUMNNAME))
FROM TABLENAME T2 WHERE T1.COLUMNNAME>=T2.COLUMNNAME) ORDER BY COLUMNNAME;

WHERE N=IS THE POSITION Source: CoolInterview.com

SELECT * FROM( SELECT a.*,ROWNUM r FROM scott.emp a
ORDER BY sal DESC) WHERE r=5 Source: CoolInterview.com

SELECT min (salary)
FROM ( SELECT salary
FROM employees
ORDER BY salary DESC)
WHERE ROWNUM < 6
ORDER BY salary Source: CoolInterview.com

Select level,max(sal) from employee
where level=5 connect by prior sal>sal group by level Source: CoolInterview.com

SELECT employee_id
, salary
FROM (SELECT employee_id
, salary
, dense_rank() over (order by salary desc) poradi -- 5th value
--, row_number() over (order by salary desc) poradi -- 5th row
FROM employees)
WHERE poradi = 5; Source: CoolInterview.com

SELECT *
FROM `employee`
ORDER BY `sallery` DESC
LIMIT 4 , 1 Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

• There should not be any Spelling Mistakes.
• There should not be any Gramatical Errors.
• Answers must not contain any bad words.
• Answers should not be the repeat of same answer, already approved.
• Answer should be complete in itself.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code: *
	Inform me about updated answers to this question