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

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

Please Help Members By Posting Answers For Below Questions

What is meant by an index?

1224

What is parameterized cursor in oracle?

1224

What are the various oracle database objects?

1204

What happens if you set the sga too low in oracle?

1223

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

1105

How many anonymous blocks can be defined?

1252

Whether any commands are used for months calculation? If so, what are they?

1139

When system tablespace is created?

1093

What is the difference between online and offline backups?

1135

How to get last row id?

1058

What are internal user account in oracle?

1055

Are truncate and delete commands same? If so why?

1204

how can we store any pdf file in oracle

2221

How to check your oracle database 10g xe installation?

1053

How to work with data objects interactively?

1043