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

Why functions are used in sql?

932

Can we edit a view in sql?

927

what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

972

What is oracle sql developer?

994

What is sequence in sql?

945

What is data control language?

949

What are expressions?

954

What is schema in sql?

887

What is primary and foreign key?

1017

What does the sign mean in sql?

921

Can we commit inside a trigger?

945

What is substitution variable in pl sql?

981

What are sql commands?

938

What is java sql driver?

1040

what is the command used to fetch first 5 characters of the string? : Sql dba

1587