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

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

1125

what is the difference between char_length and length? : Sql dba

1049

What is memory optimized table?

1049

Which are the different types of indexes in sql?

1062

Is mariadb a nosql database?

1056

What is bind reference and how can it be created?

1021

How do you exit in sql?

1113

what is sql in mysql? : Sql dba

1199

What are the basic techniques of indexing?

1065

Why do we use procedures in sql?

1089

Which table is left in join?

983

What are different types of statements supported by sql?

1165

How to take user input in pl sql?

1167

what is a trigger in mysql? Define different types of trigger. : Sql dba

1071

What are the possible values for the boolean data field?

964