select top 3 sal,depno from emp where deptno in ( select deptno from em

select top 3 sal from each dept?

Question Posted / avinesh gupta

Answer Posted / avinesh gupta

select top 3 sal,depno from emp where deptno in
(
select deptno from emp group by deptno
)
order by sal desc

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are aggregate and scalar functions?

1088

How to test for null values?

1098

What is the difference between delete and truncate commands?

1098

What is pl sql in dbms?

992

How many types of keys are there in sql?

1087

What is graph sql?

1039

What is the difference between the implicit and explicit cursors?

1111

Does sql*plus also have a pl/sql engine?

1131

what are the limitations of identity column? : Transact sql

1162

Can we use having without group by in sql?

1051

What does (*) mean in sql?

1002

what is the difference between inner and outer join? Explain with example. : Sql dba

1067

What is character functions?

1115

How many tables can a sql database have?

1029

What can you do with pl sql?

1143