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

What is a temp table?

1032

What is nosql db?

973

What are system versioned tables?

1034

What is embedded sql in db2?

1022

How can one get sql*loader to commit only at the end of the load file? : aql loader

1062

How do I install sql?

1002

how to use in conditions? : Sql dba

1015

How do I use google cloud in sql?

1094

How many functions are there in sql?

1042

Explain the difference between sql and mysql.

1066

What are the different types of tables in sql?

1010

What is t-sql? : Transact sql

993

How many rows can sqlite handle?

1121

What is the main difference between sql and pl/sql?

1103

How do I truncate a sql log file?

1079