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

What are the types of joins?

1027

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

1977

How does database replication work?

938

What are the advantages of normalizing a database.

1003

Is database a hardware or software?

942

What are indexes in oracle?

1043

Can a database table exist without a primary key?

891

can u combine pipeline parallelism and partition parallalism? how and whan?

2273

Explain the table term used in database.

985

Why do we need distributed database?

940

What is the role of tester in discovery(in Checklist)?

1921

What is a database connection string?

1070

How do I setup a database connection?

958

List the properties of a transaction.

1007

HOW WE PASS PARM PARAMETERS TO CL VARIABLES FROM RPGLE?

2586