SELECT A.EMPNAME ,A.SAL FROM EMP A WHERE A.SAL = (SELECT DISTINCT (b.sal)

how to find the n'th highest salary from emp ?

Question Posted / jaya u

Answer Posted / jaya u

SELECT A.EMPNAME ,A.SAL FROM EMP A
WHERE A.SAL = (SELECT DISTINCT (b.sal)
FROM EMP B WHERE ROWNUM = &N
ORDER BY B.SAL DESC );

Is This Answer Correct ?

0 Yes

5 No

Please Help Members By Posting Answers For Below Questions

Explain what are the type of synonyms?

1105

Explain enable novalidate constraint.

1073

What is Redo Log Buffer in Oracle?

1200

How to create id with auto_increment on oracle?

986

How to rename a tablespace in oracle?

1083

How to use group functions in the select clause using oracle?

1069

Explain the features of oracle?

1038

What is a private synonym?

1584

What are the execution control statements?

1063

What are the different oracle database objects?

1087

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

1066

How to turn on or off recycle bin for the instance?

1079

What is Trigger in Oracle?

1166

What is oracle and what are its different editions?

1064

How to use subqueries with the exists operator in oracle?

1023