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 a memo field?

969

The select into statement is most often used to create backup copies of tables or for archiving records?

1068

What are the types pl/sql code blocks?

1137

what is column? : Sql dba

1005

What makes a good primary key?

1045

what is the difference between a local and a global temporary table? : Sql dba

1073

What is the most common sql injection tool?

1043

What is the difference between the conventional and direct path loads? : aql loader

1401

What is sql*loader and what is it used for?

1155

What is case function?

1043

Why triggers are used?

993

Why coalesce is used in sql?

1014

Is sql a microsoft product?

954

Is sql better than access?

1021

What are the different operators available in sql?

1003