how to retrieve the top 3 salaries of the table using rownum
Answers were Sorted based on User's Feedback
SELECT * FROM(SELECT * FROM EMP ORDER BY SAL DESC) WHERE ROWNUM<=3;
Is This Answer Correct ? | 0 Yes | 0 No |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
Answer / manivasan.s.,
select salary from salary_table
where rownum <4
order by salary desc
Is This Answer Correct ? | 2 Yes | 5 No |
Answer / sumalatha
select top 3 esal from employee order by esal desc
Is This Answer Correct ? | 4 Yes | 18 No |
Which are the most commonly used sql joins?
What is the difference between RDBMS and DBMS?
20 Answers Practical Viva Questions, Sapient, Stag Computers,
How do you update f as m and m as f from the below table testtable?
What is application trigger?
What is sql injection owasp?
what is the difference between stored procedure and packaged procedure
How pl/sql source code can be protected?
If a procedure within a package is invalidated whether the entire package will be invalid and has to be recompiled again?
What is pseudo column ?
What is left join in postgresql?
How many joins in sql?
What is rename command in sql?