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 latest version of sql?

978

What is the use of & in pl sql?

984

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

1000

What is normalization sql?

994

Explain the difference between sql and mysql.

1000

what is 'mysqlshow'? : Sql dba

973

What does pl sql stand for?

1062

How to read/write files from pl/sql?

990

What is sp_helptext?

1004

What is minus?

940

What is the use of pl/sql table?

996

what is a constraint? : Sql dba

1100

What is #table in sql?

991

What do you mean by stored procedures?

950

How do I trace sql profiler?

919