select min(emp_sal) from (select (Emp_sal) from(select Emp

how to find the fifth highest salary?

Question Posted / nagireddy karri

Answer Posted / nagireddy karri

select min(emp_sal) from (select (Emp_sal) from(select
Emp_sal from emp order by emp_sal desc) and rownum<=5)

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is database architecture? : sql server architect

938

What is Data Independence?

938

Explain the microsoft sql server delete command? : sql server architect

847

What are the unary operations in Relational Algebra?

887

What are page splits? : sql server architect

952

Explain about the implementation of stored procedures?

921

What is database architecture?

747

What is degree of Relationship type?

889

Where the procedures are stored in database?

887

Do you know what the restrictions applicable while creating views are? : sql server architect

838

Explain about the implementation of business logic in stored procedures?

781

What do you mean by atomicity and aggregation?

955

What is the job of the information stored in data-dictionary?

851

What is an Extension of entity type?

886

What is VDL (View Definition Language)?

1052