select * from emp e where &n=(select count(distinct Sal)from emp where

select top 3 sal from each dept?

Question Posted / ramireddy

Answer Posted / ramireddy

select * from emp e where &n=(select count(distinct Sal)from
emp where Sal<=e.Sal);

Is This Answer Correct ?

2 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is full join in sql?

720

Explain what is sql?

829

What is sap sql?

721

what is sql? : Sql dba

748

Do we need commit after truncate?

818

What is data type in database?

736

What is the purpose of design view?

737

What is the advantage of index in sql?

697

How to display Row Number with Records in Oracle SQL Plus?

773

What is the difference between instead of trigger and after trigger?

705

What are the constraints available in sql?

788

What is on delete set null?

772

What is sql deadlock?

743

Can a primary key be a foreign key?

756

How do I copy a table in sql?

698