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

How to resolve name conflicts between variables and columns?

1080

Explain mutating triggers.

1088

How to insert a record into a table?

1122

What is a dead lock in oracle?

1178

How to view the tablespaces in the current database?

1027

What is the parameter mode that can be passed to a procedure?

1111

What are the uses of linked server and explain it in detail?

1118

How to select some columns from a table in oracle?

1175

What is bulk load in oracle?

1130

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2675

How to write a query with a right outer join in oracle?

1224

What is the max number of columns in an oracle table?

1048

How to use in conditions in oracle?

1116

What is the oracle implicit cursor?

1113

Difference between oracle's plus (+) notation and ansi join notation?

1160