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

how to use myisamchk to check or repair myisam tables? : Sql dba

505

What are the triggers associated with image items?

614

What is full form of rtm?

530

Is sql an operating system?

543

Can we insert data into materialized view?

502

What is the cause of mutating table error and how can we solve it?

596

How can you get sql*loader to commit only at the end of the load file? : aql loader

551

What is a function in oracle pl sql?

538

Is sql database free?

524

What are the different schemas objects that can be created using pl/sql?

522

What is assignment operator in pl sql?

561

What does over partition by mean in sql?

529

Which kind of parameters cannot have a default value in pl sql?

593

What is cursor status?

761

What is a mutating table and a constraining table?

567