select sal from emp e where 5=(select count(sal) from emp e1 wher

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

Question Posted / dramesh511

Answer Posted / dramesh511

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

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can you explain new content durability?

968

Why cognos decision stream is used?

1070

1. Explain your project.

1974

Explain what is the difference between microstrategy and cognos reporting tool?

999

What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?

1110

Hi Buddies...i am lalitha. i am willing to appear for cognos bi-author certification. can anyone of you send me cognos dump. please please help me.

1796

What are the advantages of shortcuts?

909

What are the components of the report studio?

1111

What is the difference between a cascading report and drill through the report?

1112

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

1947

What is the difference between regular dimension and derminant?

2195

Can you define cognos decision stream?

945

New coloums are added in database, then how you know in report level

1512

What is called a slice?

972

What are the steps to import the two data sources in framework manager?

977