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

Is pl sql better than sql?

1046

What is the command used to fetch the first 5 characters of a string?

1217

What is clustered index sql?

993

what are the different index configurations a table can have? : Sql dba

1005

What is difference between stored procedures and application procedures?

1026

Is sql port 1433 encrypted?

1039

Can we rollback after truncate?

1036

what is single byte over head in oracle..?

2413

What is execution plan in sql?

1057

What is pivot query?

1084

What is difference between db2 and sql?

1010

Why we use cross join?

965

What is the difference between an inner join and an outer join?

1037

What is aggregate function in sql?

1041

What is mutating error in pl sql?

1033