a query to select maxmun 3 salaries of employee table
- 12 Answers
- 16727 Views
- IBM, Polaris, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / tulasi
select * from (select * from emp order by sal desc) where
rownum<=3;
| Is This Answer Correct ? | 21 Yes | 5 No |
Answer / krishna kumar r
SELECT E1.ENAME,E1.SAL FROM EMP E1 WHERE 3>(SELECT COUNT(*)
FROM EMP E2 WHERE E2.SAL>E1.SAL ) ORDER BY SAL DESC
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / chaitanya
Select sal from emp order by desc fetch first 3 rows only;
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / munna
select * from emp e where &n=(select count(distinct sal)
from emp ee where e.sal<=ee.sal);
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / suresh babu
select * from employees a where 3 <= select count(distinct
b.salary) from employees b where a.salary >= b.salary);
This query,which returns the first maximum salary from
employees table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / dhanya
select rnk, no,sal from (
SELECT DENSE_rank()over(partition by no order by sal desc ) RNK,d2.no,sal FROM DUMMY2 d2)
where rnk =2;
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / kannan
select * from emp
where sal in (select max(sal) from emp
where level<=3
connect by prior sal>sal
group by level)
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / raju
select * from emp a where 3>=(select count(distinct(b.sal))
from emp b where b.sal>=a.sal )
| Is This Answer Correct ? | 4 Yes | 6 No |
select top 3 salary from employee order by salary desc
| Is This Answer Correct ? | 5 Yes | 7 No |
Answer / ron
if you need to select by department then analytic function
is more readable:
1. use row_number() partition by dept order by sal desc as rn,
2. in where clause choose rn <4;
you can use rank() instead; if 2 or more employees have same
salary.
| Is This Answer Correct ? | 0 Yes | 3 No |
can we insert any row to dual table if i got the permission from DBA
Explain cascading triggers.
How can we find out the current date and time in oracle?
how to use sequence and what use of sequence cache
What is a cluster Key ?
Whats the benefit of dbms_stats over analyze?
How many types of tables are there in oracle?
What are the types of partitions in oracle?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
Hi can anyone tell me where are the dumps found of OCA certification.. Also the materials to be studied for the preparation.
Does oracle database need java?
how to select second mauximum value in a given table under salary column
Oracle General 
