select * from (select sal,rank() over (order by sal desc) emprank from em

select top 3 sal from each dept?

Question Posted / sasi

Answer Posted / sasi

select * from
(select sal,rank() over (order by sal desc) emprank from emp)
where emprank<=3

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How does a trigger work?

1019

What are the commands used in sql?

1033

what are sequences

1692

Compare sql & pl/sql

1079

What is a dynamic query?

992

What are different clauses used in sql?

1096

Define commit, rollback and savepoint?

996

What are the types of join and explain each?

1006

What is t sql used for?

991

Is pl sql useful?

948

What are the parts of a sql statement?

1051

what is the syntax for using sql_variant_property? : Transact sql

1007

What is pl sql commands?

1011

What is set transaction?

1004

Can we insert data in view?

922