SELECT DISTINCT SAL FROM EMP E WHERE 5>=(SELECT COUNT(DISTINCT SAL) FROM

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

Question Posted / dhanu

Answer Posted / dhanu

SELECT DISTINCT SAL FROM EMP E WHERE 5>=(SELECT COUNT(DISTINCT SAL) FROM EMP A WHERE A.SAL<=E.SAL)ORDER BY SAL DESC

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

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

1075

what is a prompt value in report studio and variables ?

2716

What is difference between data mart and data warehouse?

979

Can you define a datastore in cognos?

1039

what are the dimensions that you have in your current project?list them?

2072

What DB View and Bus View?

1974

What is dtm?

1170

what is requery in cognos?

2484

1. Explain your project.

2048

Which studio is used to create reports?

1108

What is the size of database for you project?

1597

What are all the types of gateway used in Cognos?

1031

Can you explain dynamic query mode?

1058

WHAT ARE THE DISTNICT VARIABLES?

2265

Can you define bitmap index?

1063