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 |
Is nosql faster than sql?
query to retrive the employees whose sal is greater than avg sal
In testing where do we use sql language and how it helps in testing?
How many null values can be inserted in a coulmn whihc is unique constraint
What are inner and outer joins examples of both?
Does mysql support pl sql?
Who developed sql?
I need a function for a train ticket reservation please answer it thanks in advance
What are the types of index in sql?
What is example of database?
Which data type doesn't allow null data type?
What is sql prepared statement?