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 the meaning of recursive hints in oracle?

1046

Can you create a synonym without having a table?

1041

How to apply filtering criteria at group level in oracle?

1042

Differentiate between pre-select and pre-query?

1106

What are the differences between number and binary_float in oracle?

1100

How to import one table back from a dump file?

1025

Which is better Oracle or MS SQL? Why?

6386

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1999

Difference between oracle's plus (+) notation and ansi join notation?

1100

What is a static data dictionary in oracle?

1112

What are the different pseudo commands? Explain in general?

1080

What is Reduced List of Values?

2164

What is a table in oracle?

979

What is an oracle recycle bin?

1009

What is an anonymous block?

1241