with Q as (select *,dense_rank() over(partition by dept order by sal) as

select top 3 sal from each dept?

Question Posted / keshav

Answer Posted / keshav

with Q as (select *,dense_rank() over(partition by dept
order by sal) as dr from dept
select * from Q
where dr=3

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is difference between sql function and stored procedure?

689

How to change sql*plus system settings?

723

What is the unique index?

728

What do you mean by “trigger” in sql?

801

What are the types pl/sql code blocks?

797

What is sql basics?

782

what is a composite primary key ? : Sql dba

782

What is flag in sql?

743

what is 'mysqladmin' in mysql? : Sql dba

744

what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

760

how can we submit a form without a submit button? : Sql dba

730

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

709

Is json a nosql?

723

What is an oracle stored procedure?

784

What is trigger in flip flop?

731