select * from emp where sal =(select sal from(select sal,rank() over(order

Write a SQL query which should fetch the 5th maximum salary
of an employee from the table?

Question Posted / balanandam

Answer Posted / balanandam

select * from emp where sal =(select sal from(select sal,rank() over(order by sal desc) sal_rank from emp group by sal) where sal_rank=&rank)

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can you define a catalog and types of catalogs in cognos?

1095

Define cognos report net?

1010

Define query items?

1051

how you migrate reports to cognos 8 from previous versions?

1095

Name the types of gateway?

1044

What do you understand by the term 'aggregate advisor?'

1010

After applying date prompt and when we run the report we fet from date and todate prompts..so when we enter todate

2090

How to do Performence Tunning in Cognos Reports?

2530

-----------With out using DrillThrough how to do Reports?

2092

Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days

3668

Explain about scorecarding?

2119

How to join multiple db in catalog?

1063

How do we drill through from a powerplay cube to reportnet?\

2401

Can you explain dynamic query mode?

1102

What is defined as catalog and types of catalogs in Cognos?

1199