1. Categories >> Software >> Databases >> Database Management
  2. Suggest New Category

select Nth highest salary by using rownum

Question Posted / siva kumar

Answers were Sorted based on User's Feedback



select Nth highest salary by using rownum..

Answer / srinu

SELECT * FROM EMP WHERE SAL=(SELECT MIN(SAL) FROM ( SELECT
DISTINCT(SAL) FROM EMP ORDER BY SAL DESC) WHERE ROWNUM<'&N');

ANS::

EMPNO ENAME JOB MGR HIREDATE SAL
COMM DEPTNO
------ ---------- --------- ---------- --------- ----------
---------- ----------
7566 JONES MANAGER 7839 02-APR-81 2975
20

SELECT * FROM EMP WHERE SAL=(SELECT MIN(SAL) FROM ( SELECT
SAL FROM EMP ORDER BY SAL DESC) WHERE ROWNUM<'&N');



EMPNO ENAME JOB MGR HIREDATE SAL
COMM DEPTNO
------ ---------- --------- ---------- --------- ----------
---------- ----------
7788 SCOTT ANALYST 7566 19-APR-87 3000
20
7902 FORD ANALYST 7566 03-DEC-81 3000
20

Is This Answer Correct ?    8 Yes 0 No

select Nth highest salary by using rownum..

Answer / siva kumar

select rownum,empno,ename,sal from(select * from emp order by
sal desc)group by rownum,empno,ename,sal having rownum='&n'

Is This Answer Correct ?    6 Yes 2 No

select Nth highest salary by using rownum..

Answer / xxx

SELECT * FROM EMP WHERE N=(SELECT COUNT(DISTINCT SAL) FROM EMP
WHERE SAL>=e.SAL);

Is This Answer Correct ?    3 Yes 0 No

select Nth highest salary by using rownum..

Answer / welcomeashwin

SELECT * FROM HR.EMPLOYEES EMP1
WHERE &N=(
SELECT COUNT(DISTINCT(SALARY))
FROM HR.EMPLOYEES EMP2
WHERE EMP1.SALARY<=EMP2.SALARY
);

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Database Management Interview Questions

What are the types of database management system?

0 Answers  

What is Database testing and What are ways of writing test cases for database testing?

0 Answers   Ittiam Systems,

How do you create a simple database?

0 Answers  

What is database url?

0 Answers  

Why do not you use gnu autoconf or scons for building?

0 Answers  




What are foreign keys in database?

0 Answers  

Enlist various transaction phases.

0 Answers  

if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?

1 Answers  

Explain 3nf?

0 Answers  

What do you mean by e-r model & object-oriented model?

0 Answers  

what is scan listener.

0 Answers  

What is the structure of a table in database?

0 Answers  

For more Database Management Interview Questions Click Here
Categories