how to retrieve the top 3 salaries of the table using rownum

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

Question Posted / deva

31 Answers
33784 Views
Oracle, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to retrieve the top 3 salaries of the table using rownum..

Answer / chandrasekar.ramasamy

select sal from( select rownum,e.* from empmaster e order
by sal desc) where rownum < 4

Is This Answer Correct ?

20 Yes

7 No

how to retrieve the top 3 salaries of the table using rownum..

Answer / dhiman sarkar

select empname,sal from (select empname,sal from dh1 order
by sal desc)
where rownum < =4
order by sal desc

Is This Answer Correct ?

17 Yes

7 No

how to retrieve the top 3 salaries of the table using rownum..

Answer / kalyan kumar

select e.ename,e.sal from emp e where 3>(select count
(distinct(b.sal)) from emp b where b.sal>e.sal)

Is This Answer Correct ?

19 Yes

10 No

how to retrieve the top 3 salaries of the table using rownum..

Answer / vik

select empno, ename, sal from (select * from emp order by
sal desc) where rownum < 4

Is This Answer Correct ?

8 Yes

1 No

how to retrieve the top 3 salaries of the table using rownum..

Answer / nilesh

You can also use a query like

select e.ename,e.sal from emp e where 3>(select count
(distinct(b.sal)) from emp b where b.sal>e.sal)

as explained by Kalyan Kumar in Answer 2 and for making
it parameterised u can replace 3 by &sal so that when it is
executed it will ask you a number
if you enter 3 it will give you best three salaries , if
you enter 4 it will give you best 4 salaries etc.

Is This Answer Correct ?

9 Yes

3 No

how to retrieve the top 3 salaries of the table using rownum..

Answer / rameshwar gupta

select ename ,sal from (select ename,sal from emp order
by sal desc)
where rownum<4

Is This Answer Correct ?

8 Yes

3 No

how to retrieve the top 3 salaries of the table using rownum..

Answer / moorthy(information dynamic)

select sal,rank()over (order by sal desc) from emp where
rownum < = 3;

Is This Answer Correct ?

3 Yes

0 No

how to retrieve the top 3 salaries of the table using rownum..

Answer / nitesh

select sal from emp e where 3>=(select count(distinct sal)
from emp where sal>e.sal) order by sal desc;

Is This Answer Correct ?

5 Yes

3 No

how to retrieve the top 3 salaries of the table using rownum..

Answer / akki julak

select sal from (select rownum,sal from emp order by sal
desc)
where rownum<4;

Is This Answer Correct ?

2 Yes

0 No

how to retrieve the top 3 salaries of the table using rownum..

Answer / swapnareddy

select sal from emp a where 3>(select
count(distinct(sal))from emp b where a.sal<b.sal);

Is This Answer Correct ?

4 Yes

3 No

Post New Answer