select * from ( select sal,rownum as num from (select sal from emp order

select top 3 sal from each dept?

Question Posted / kishore

Answer Posted / kishore

select * from (
select sal,rownum as num from (select sal from
emp order by sal desc))
where num <=3;

Is This Answer Correct ?

0 Yes

4 No

Please Help Members By Posting Answers For Below Questions

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

1188

Why does sql need a server?

1039

How to start oracle sql developer?

1035

What is sql dialect?

1116

Is sql injection illegal?

1021

What are the advantages of sql? Explain

1106

How does sql*loader handles newline characters in a record? : aql loader

1044

What is the difference between alter trigger and drop trigger statements?

1109

What is trigger explain it?

1015

Why do we use joins?

1038

Why do we need a foreign key?

1094

How do you pronounce sql?

1011

Which sql most popular?

988

How to create an array in pl/sql?

1066

What does plv msg allows you to do?

1141