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 is the process of copying data from table a to table b?

805

What is the difference between sql and isql*plus?

706

What does the file extension accdb stand for?

710

What is the use of pl/sql table?

758

what is a primary key? : Sql dba

752

How many joins can you have in sql?

687

What is the use of procedures?

716

Can we insert data into materialized view?

712

How many sql statements are used? Define them.

778

What is a .db file?

726

Can sql function call stored procedure?

743

Mention what is the use of function "module procedure" in pl/sql?

787

how to use like conditions? : Sql dba

786

what are the 'mysql' command line arguments? : Sql dba

839

What is foreign key and example?

708