SELECT * FROM (SELECT NAME,SALARY FROM EMP ORDER BY SALARY DESC) WHERE R

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

Question Posted / mukesh kumar

Answer Posted / mukesh kumar

SELECT * FROM (SELECT NAME,SALARY FROM EMP ORDER BY SALARY
DESC)
WHERE ROWNUM < 3

Is This Answer Correct ?

1 Yes

7 No

Please Help Members By Posting Answers For Below Questions

How do I view a sql trace file?

568

Why we use triggers in mysql?

560

how to use in conditions? : Sql dba

514

What is an ndf file?

534

Could you please provide oca (oracle 10g) dumps for my certification ?

4515

define sql insert statement ? : Sql dba

552

What are the various levels of constraints?

670

What is duration in sql profiler trace?

557

How to create your own reports in sql developer?

544

Why functions are used in sql?

515

Why we use pl sql?

531

What is posting?

611

What found sql?

530

How do I view tables in sql developer?

518

Which table is left in left join?

531