SELECT EMP_NAME (SELECT ROWNUM R,B.* FROM employee B ORDER BY SALARY DESC

How to get employee name from employee table which is the
fiveth highest salary of the table

Question Posted / shashidhar

Answer Posted / shashidhar

SELECT EMP_NAME (SELECT ROWNUM R,B.* FROM employee B ORDER
BY SALARY DESC) A
WHERE A.R = 5

Is This Answer Correct ?

4 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Why functions are used in sql?

988

how to use in conditions? : Sql dba

1009

How do I tune a sql query?

970

how to convert character strings to dates? : Sql dba

1051

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

1111

What is sql profiling in oracle?

1056

What are the uses of sysdate and user keywords?

1099

What is a unique key?

1050

What is update query?

972

Can we use threading in pl/sql?

1036

What is the difference between microsoft sql and mysql?

958

What are the possible values that can be stored in a boolean data field?

996

Which is faster joins or subqueries?

986

How does cross join work in sql?

1010

What is field delimiter?

1042