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 pl/sql table? Why is it used?

561

What is the difference between a subquery and a join?

529

How can you know that statistics should be updated?

606

How many types of literals are available in pl sql?

516

Can sql developer connect to db2?

587

what does the t-sql command ident_current does? : Transact sql

546

Can you call pl/sql package functions from within a fast formula?

564

What are the methods of filing?

520

What is the purpose of design view?

527

how to rename an existing column in a table? : Sql dba

514

Can we use distinct and group by together?

588

How to load data with sql*loader?

552

how does a local variable is defined using t-sql? : Transact sql

546

What is the use of non clustered index?

528

Write the alter statement to enable all the triggers on the t.students table.

674