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
36927 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 / raghunanda

SELECT * 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 / d.elumalai

CREATE TABLE EMP (NAME VARCHAR2(20),SALARY NUMBER(10));

INSERT INTO EMP VALUES('AAA',10000);
INSERT INTO EMP VALUES('BBB',20000);
INSERT INTO EMP VALUES('CCC',30000);
INSERT INTO EMP VALUES('DDD',40000);
INSERT INTO EMP VALUES('EEE',50000);
INSERT INTO EMP VALUES('FFF',60000);
INSERT INTO EMP VALUES('GGG',70000);
INSERT INTO EMP VALUES('HHH',80000);
INSERT INTO EMP VALUES('III',90000);
COMMIT;

SELECT A.* FROM (SELECT name, salary FROM EMP ORDER BY salary DESC) A WHERE ROWNUM<=3;

Is This Answer Correct ?

0 Yes

0 No

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

Answer / muneer ahamed

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

Is This Answer Correct ?

4 Yes

5 No

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

Answer / phantom coding

select * from (select rownum as rnum,t.* from emp order by
sal desc) a where rnum < 4

the alias to rownum (i.e:rnum) should be used. If rownum is
used for the constraint then the query would return the
first three rows it hits and the results could be wrong.

Is This Answer Correct ?

1 Yes

2 No

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

Answer / ram

Select * from emp
where emp.salary in (select emp.salary from emp
where (select distict salary
from emp order by desc null last)
where rownum <=3);

Is This Answer Correct ?

1 Yes

2 No

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

Answer / nasir iqbal

SELECT * FROM EMP A WHERE 1=(SELECT COUNT (*) FROM EMP B
WHERE B.SAL>=A.SAL)
SELECT * FROM EMP

Is This Answer Correct ?

1 Yes

2 No

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

Answer / debanjan rudra

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

Is This Answer Correct ?

0 Yes

1 No

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

Answer / ashwinee

select empnumber
from emp
where rownmum < 4 and salary in (select salary
from emp
order by salary desc)

Is This Answer Correct ?

0 Yes

2 No

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

Answer / manivasan.s.,

select salary from salary_table
where rownum <4
order by salary desc

Is This Answer Correct ?

2 Yes

5 No

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

Answer / sumalatha

select top 3 esal from employee order by esal desc

Is This Answer Correct ?

4 Yes

18 No

Post New Answer