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

What is the current version of sql?

973

How does an execution block start and end in pl sql?

900

Can ddl statements be used in pl/sql?

1068

Explain the significance of the & and && operators in pl sql.

950

explain about mysql and its features. : Sql dba

969

Explain raise_application_error.

1042

Explain some predefined exceptions.

990

What is the difference between delete, truncate and drop command?

1060

What are the indexing methods?

1002

What is the limitation on the block size of pl/sql?

936

Will truncate release space?

887

What is recursive join in sql?

946

What is rollback?

1035

What is the purpose of the sql select top clause?

1019

How do I run a sql query in pgadmin 4?

905