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 I count rows in sql?

948

What is anonymous block in sql?

1076

Which is faster count (*) or count 1?

969

what is dbms? : Sql dba

934

Can we use two order by clause in query?

919

What is the best sql course?

934

Can we use having without group by in sql?

929

How do I save a sql query?

962

Are left and right joins the same?

1003

What are pl sql procedures?

966

What are sql*plus environment variables?

1032

Which is faster view or stored procedure?

889

how to rename an existing column in a table? : Sql dba

962

How exception handling is done in advance pl/sql?

920

Mention what does plv msg allows you to do?

1053