Interested to Buy Any Domain ? << Click Here >> for more details...
a query to select maxmun 3 salaries of employee table
- 12 Answers
- 20715 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 |
What are the types of synonyms?
What are the most common interview questions on ETL Testing for experience?
Explain a synonym?
Why cursor variables are easier to use than cursors?
What is the difference between 10g OEM and 11g OEM?
Is there any function in oracle similar like group_concat of mysql?
What is a nvl function? How can it be used?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
In Oracle 10g, "g" Stands for what?
if i have a procedure with 1000 line.when i run this in 61 line i got the error but i want to continue the programe without error.can anyone tell me how to handle that error.
What is the effect of setting the 'RULE' for OPTIMIER_GOAL parameter of the ALTER SESSION Command ?
Explain do view contain data?
Oracle General 
