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 do you write a subquery?

1070

What is sql*loader?

1285

What is plpgsql language?

1142

What are crud methods?

1086

Can a foreign key have a different name?

996

How are functions and procedures called in PL/SQL?

1308

Can we join tables without foreign key?

1007

Can cursors be part of a trigger body?

1693

how to return query output in html format? : Sql dba

1121

What is the difference between inner join and natural join?

1057

what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

1093

Which are the different case manipulation functions in sql?

1077

Does db2 use sql?

1009

What is sqlservr exe?

1028

what is the difference between truncate and drop statements? : Sql dba

1181