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

Explain correlated query work?

1059

Why do we use %rowtype & %type in plsql?

1055

how tsql statements can be written and submitted to the database engine? : Transact sql

1002

What are analytic functions in sql?

1034

how to do backup entire database? : Transact sql

1149

What type of database is sql?

1032

What are the different tcl commands in sql?

1183

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

978

How many types of cursors supported in pl/sql?

1197

What is the sql case statement?

1012

How to use boolean type in select statement?

1084

How do you use join?

947

What is an invalid partition table?

1030

What is pl sql script?

1036

What is exit statement?

1020