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

How can you load multi line records? : aql loader

1072

What is difference between group by and partition by?

1055

How to rename a column in the output of sql query?

1072

What is the difference between rename and alias?

1341

Can we update views in sql?

938

Can we insert in sql function?

1081

Can we join tables without foreign key?

958

What is data manipulation language?

1187

What is the mutating table and constraining table?

1024

Why primary key is required?

1003

What is relationship? How many types of relationship are there?

1174

What is primary key sql?

1032

Is postgresql a server?

1046

How can I tell if sql is running?

1064

What are sql*plus environment variables?

1093