select min(salary) from (select rownum r,e.* from employees e order by sala

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

Question Posted / vijay

Answer Posted / vijay

select min(salary) from (select rownum r,e.* from employees e order by salary desc) where rownum<=5;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Is sql a backend language?

1145

Explain the methods used to protect source code of pl/sql.

1074

List the different type of joins?

1113

What is execute immediate?

1163

Enlist the advantages of sql.

1052

Can we insert delete data in view?

1002

Why do we go for stored procedures?

1126

What is primary key and foreign key with example?

981

what is the difference between $message and $$message? : Sql dba

1040

What is trigger in sql and its types?

1113

How do I view tables in sql developer?

1009

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

1019

How can I get the number of records affected by a stored procedure?

1118

Why truncate is used in sql?

1043

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2611