select * from emp e where &n=(select count(distinct sal) from emp ee

a query to select maxmun 3 salaries of employee table

Question Posted / munna

12 Answers
20186 Views
IBM, Polaris, I also Faced
E-Mail Answers

Answer Posted / munna

select * from emp e where &n=(select count(distinct sal)
from emp ee where e.sal<=ee.sal);

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How can I get column names from a table in oracle?

1031

How to speed up webrick?

1050

Explain do view contain data?

981

What is blob datatype?

1097

What are the differences between lov and list item?

1043

Can we connect to ORACLE db using Windows Authentication?

1228

what is difference between sql plus and sql*plus? (not sql and sql plus).

3872

What are the database administrators utilities available?

1006

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1935

What are the uses of synonyms?

1129

What is index-organized table in Oracle?

1052

What is a table index?

1071

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

2943

What is oracle join syntax?

982

What are the system predefined user roles?

1025