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 embedded sql with example?

989

What is dynamic sql in pl sql?

984

how many tables will create when we create table, what are they? : Sql dba

1022

define data blocks ? : Sql dba

932

Explain select statements in sql?

1003

Is primary key an index?

947

what is the different between now() and current_date()? : Sql dba

938

What is numeric function sql?

988

Why is there a need for sqlcode and sqlerrm variables?

999

what is 'mysqlshow'? : Sql dba

975

When should I use nosql database?

946

what is blob? : Sql dba

1057

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

1047

Can we use delete in merge statement?

1002

How do you drop a trigger?

924