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

How to read xml file in oracle pl sql?

921

How do you declare a user-defined exception?

1034

What are the advantages of sql?

1065

What are %type and %rowtype for?

1064

What are aggregate and scalar functions?

1037

Is sqlite good enough for production?

1003

Which certification is best for sql?

998

Can a trigger call a stored procedure?

1079

What is sql key?

1001

Does pl sql work in mysql?

989

how would you enter characters as hex numbers? : Sql dba

995

What does pragma mean?

1064

Can we use delete in merge statement?

1050

What is synchronized subquery?

1179

how many sql ddl commands are supported by 'mysql'? : Sql dba

1033