select * from emp e where 5=(select count(distinct sal) from emp e where

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

Question Posted / pavan kumar

Answer Posted / pavan kumar

select * from emp e where 5=(select count(distinct sal)
from emp e where e.sal<=sal)

Is This Answer Correct ?

3 Yes

8 No

Please Help Members By Posting Answers For Below Questions

What is the size of database for you project?

1555

What are the different types of reports present in cognos?

938

Can you define slice?

976

What do you understand by the term 'dynamic cube'?

937

what are the errors faced while bursting the reports and how to solve those errors?

1951

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

1988

What is the metric store database?

916

What is catalog and types of catalogs in cagonos and which is better?

930

What is the difference between low affinity and high affinity connections?

961

What do you understand by ‘ibm predictive maintenance and quality’?

936

What is the deployment requirements used in cognos?

1595

Can you define framework manager?

970

What are the components of the report studio?

1112

How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?

2514

write a query to display the departments with no employee?

1918