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

What is a trigger oracle?

1093

What to do if dba lost the system password?

1176

Can we store images in oracle database?

1013

Can you create a synonym without having a table?

1046

What is background process in Oracle?

1108

What is index-organized table in Oracle?

1072

Explain user account with reference to oracle.

994

Can you have more than one content canvas view attached with a window ?

2333

What do you mean by group by clause?

1050

what are the advantages of running a database in archive log mode?

2205

What is query image?

985

What happens if you set the sga too low in oracle?

1156

How to declare a local variable?

1126

How remove data files before opening a database?

1078

What happens to indexes if you drop a table?

1172