Select * from emp where sal in (Select * From (Select sal from emp order b

i need department wise top 2 employees salary.which logic
i will use

Question Posted / ramya p

Answer Posted / ramya p

Select * from emp where sal in
(Select * From (Select sal from emp order by sal desc)
Where rownum < 3) order by sal desc;

Is This Answer Correct ?

6 Yes

18 No

Please Help Members By Posting Answers For Below Questions

What is gpt format?

509

Explain foreign key in sql?

621

What is vector point function?

571

What is data profiling in sql?

517

Why do we go for stored procedures?

525

How do I audit the sql sent to the server?

526

Why procedure is used in sql?

535

How to order siblings in oracle hierarchy queries?

600

What are the features of pl sql?

563

What is native sql query?

554

How does cross join work in sql?

535

Are subqueries faster than joins?

577

What is the maximum number of triggers, you can apply on a single table?

544

What is partition in sql query?

519

how to present a past time in hours, minutes and seconds? : Sql dba

566