Interested to Buy Any Domain ? << Click Here >> for more details...
a query to select maxmun 3 salaries of employee table
- 12 Answers
- 19845 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 |
How to Remove the 3rd highest salary person record from table?
Explain the importance of .pll extension in oracle?
I have one table :EID,Depid,ename,sal I want to have max(sal) in each department.
5 Answers Microsoft, Oracle, TCS,
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
What is a table index in oracle?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
Explain oracle 12c new features for developers?
What is meant by joins?
Display the order number and the number of months since the order was shipped for all orders that have been shipped in the last year (365 days). (Hint: Unshipped orders will have a null value).
How to connect to a local oracle 10g xe server?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
Oracle General 
