select top 3 sal from each dept?
Answers were Sorted based on User's Feedback
Answer / avinesh gupta
select top 3 sal,depno from emp where deptno in
(
select deptno from emp group by deptno
)
order by sal desc
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / sambu
select r.sal,r.rank,r.dept high from
(select deptno,sal,dense_rank() over (partition by deptno
order by sal desc) rank
from emp) r
where r.rank=3;
The above query gives the following result
DEPTNO SAL HIGHEST
------ ----- -------
10 1300 3
20 1100 3
30 1500 3
Is This Answer Correct ? | 3 Yes | 7 No |
Answer / kishore
select * from (
select sal,rownum as num from (select sal from
emp order by sal desc))
where num <=3;
Is This Answer Correct ? | 0 Yes | 4 No |
Answer / neetika vardhan
SELECT DEPT, MAX(SAL)
FROM EMP
WHERE SAL NOT IN (SELECT MAX(SAL) FROM EMP GROUP BY DEPT)
GROUP BY DEPT
UNION
SELECT DEPT, MAX(SAL)
FROM EMP
GROUP BY DEPT
UNION
SELECT DEPT, MAX(SAL)
FROM EMP
WHERE SAL NOT IN
(SELECT MAX(SAL)
FROM EMP
WHERE SAL NOT IN (SELECT MAX(SAL) FROM EMP GROUP
BY DEPT)
GROUP BY DEPT
UNION
SELECT MAX(SAL) FROM EMP GROUP BY DEPT)
GROUP BY DEPT
Is This Answer Correct ? | 0 Yes | 6 No |
Answer / sen
select *
(select sal from emp
order by 1 desc)
where rownum < 4
Is This Answer Correct ? | 1 Yes | 13 No |
Which version of sql do I have?
What is a field in a database?
what is the differnce between procedure and function? in both dml operations can work and in procedure through out parameter you can return value ,then what is the differce?
What is the best free sql database?
What is cursor in pl sql?
How does cross join work in sql?
What are the different dml commands in sql?
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
How many aggregate functions are available there in sql?
What is data types in sql?
How do I enable sql encryption?
Is pl sql and postgresql same?