select Salary from ( select salary from emp order by desc) as employee wher

write a query for the fifth highest salary?

Question Posted / chethan

Answer Posted / chethan

select Salary from ( select salary from emp order by desc) as employee where rownum = 5;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain natural key?

622

What is the concept of Virtual field?

1626

What is dialect in database?

563

Explain entity set?

590

What is the difference between a stored procedure and a query?

596

What is database server and how it works?

557

if i want to display the name of students such that to which city they belong must have count greaer than two

1788

What is global database name?

553

What is the purpose of firebase?

550

Is it good to store images in database?

550

What is the difference between specialization and generalization?

584

HOW PASS PARAMETERS FOLLOWING ORDER RPG-CL-RPG?

1986

Difference between sql and mysql?

1632

where can i free download sqlserver2008..i can install sqlserver2008 without visual studio 2008 and work on it

1581

List various types of log-based recovery in DBMS.

575