select * from(select ename,deptno,sal from emp order by sal desc) where row

select top 3 sal from each dept?

Question Posted / anil

Answer Posted / anil

select * from(select ename,deptno,sal from emp order by sal desc) where rownum<=3

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is nvarchar max in sql?

582

What will you get by the cursor attribute sql%rowcount?

551

What is the purpose of normalization?

537

Can we use two order by clause in query?

543

What is blind sql injection?

578

Does db2 use sql?

512

How you improve the performance of sql*loader? : aql loader

580

What is the difference between a subquery and a join?

529

Why cross join is used?

637

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

620

How long does it take to learn pl sql?

610

What is the full form of sql?

534

how to calculate the difference between two dates? : Sql dba

550

what is csv? : Sql dba

578

What is the use of procedures?

546