a query to select maxmun 3 salaries of employee table
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 |
How to install oracle odbc drivers?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
How do I know if oracle is installed on windows?
How to define Data Block size ?
How to update values in a table in oracle?
What is a procedure in oracle?
Why do we use bulk collect in oracle?
How you open and close a cursor variable.Why it is required?
Explain cascading triggers.
Explain oracle left join with an example?
What is a trigger and what are its types?