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

How do you write a subquery?

1070

Is sql considered coding?

1089

What are pl/sql cursors?

1104

What is difference between stored function and application function?

1290

what is isam? : Sql dba

1067

What is full form of rtm?

1056

What is compiled query?

1089

What is sorting in sql?

986

Explain what is rdbms?

1091

What is rownum in sql?

1095

Can one improve the performance of sql*loader? : aql loader

1099

Which data dictionary views have the information on the triggers that are available in the database?

1301

What are the indexing methods?

1099

Can you skip header records while loading? : aql loader

1102

how would you enter characters as hex numbers? : Sql dba

1038