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

What are schema-level triggers?

1102

What are sql built in functions?

936

Does inner join remove duplicates?

942

Is a foreign key always unique?

942

Do we need to create index on primary key?

929

When are we going to use truncate and delete?

989

What is rollback?

1115

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

1003

What is primary key and foreign key with example?

932

Describe sql comments?

1044

What is difference between inner join and cross join?

969

What are the different parts of a package?

1115

How much does a sql dba make? : SQL DBA

947

How do you rename a table in sql?

1113

How does pl sql work?

965