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

How to assign values to data fields in record variables?

1038

What is the difference between count (*), count (expression), count (distinct expression)?

1013

How to do clean up if create database failed?

1033

What is private procedure oracle?

1014

What is an oracle function?

1172

What is Redo Log Buffer in Oracle?

1211

What are the database administrators utilities available?

1036

Explain temporal data types in oracle

1098

What are the benefits of ordbms?

1088

How to use subqueries with the exists operator in oracle?

1027

What is the fastest query method to fetch data from the table?

1368

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1994

What is the difference between formal parameters and actual parameters?

1090

what are actual and formal parameters?

1106

What is the difference between a hot backup and a cold backup in oracle?

1021