Select * from emp A where 2>=(select count(distinct(B.sal)) from emp B w

select top 3 sal from each dept?

Question Posted / ashwini

Answer Posted / ashwini

Select * from emp A where 2>=(select count(distinct(B.sal)) from emp B where A.sal<B.sal);

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is sql partition?

1165

What does varchar include?

994

how to present a past time in hours, minutes and seconds? : Sql dba

1071

What do we need to check in database testing?

1063

Is sql scripting language?

1115

What is cte?

1022

What is a pragma statement?

1335

Can a table contain multiple primary key’s?

1155

Which one is faster ienumerable or iqueryable?

989

How to select 10 records from a table?

1207

What is the difference between join and natural join?

984

Is keyword pl sql?

1057

Explain what is a field in a database and record in a database?

1180

Is left join inner or outer?

1057

Is clustered index a primary key?

988