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
40600 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 / seema

select sal from (select distinct sal from emp order by sal
desc ) where rownum < 3;

Is This Answer Correct ?

1 Yes

0 No

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

Answer / kavitha

select employee_id,last_name,salary
from employees
where rownum <=3
order by salary desc

Is This Answer Correct ?

1 Yes

1 No

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

Answer / kamal

Hello Sir

I wana to see this that how to retrieve 3 top salary by
subqurey can you gave me this answer.

Thanks

Is This Answer Correct ?

0 Yes

0 No

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

Answer / saisravanthi

select salary from
(select salary,rownum from salary_tab
order by salary_tab desc)
where rownum < 4;

Is This Answer Correct ?

0 Yes

0 No

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

Answer / manoj tcs

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

Is This Answer Correct ?

0 Yes

0 No

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

Answer / raveendran

SELECT EMP_BASICS,ROWNUM FROM EMPLOYEE_MASTER WHERE
EMP_BASICS IS NOT NULL AND ROWNUM<=3 ORDER BY EMP_BASICS
DESC

Is This Answer Correct ?

0 Yes

0 No

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

Answer / k.thrilok kumar

select rownum, sal from (select * from emp order by sal
desc) where rownum<=3

Is This Answer Correct ?

0 Yes

0 No

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

Answer / rajnish chauhan

you can put any number on Rnk.

---Top 3 salary
SELECT ROWNUM,ename,sal
FROM (
SELECT ename,sal,rank() over(ORDER BY sal DESC)rnk
FROM emp)a WHERE rnk<4

-----Top 3 Salary only
SELECT ROWNUM,ename,sal
FROM (
SELECT ename,sal,rank() over(ORDER BY sal DESC)rnk
FROM emp)a WHERE rnk=3

Is This Answer Correct ?

0 Yes

0 No

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

Answer / debbie

select * from (select sal from emp order by sal desc)
where rownum<=3

Is This Answer Correct ?

0 Yes

0 No

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

Answer / chiru

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

Is This Answer Correct ?

0 Yes

0 No

Post New Answer