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

What is compound trigger?

752

What are the differences between in and exists clause?

784

What is auto increment?

733

What is the sql case statement?

749

What is the difference between microsoft access and sql?

725

Can a composite key be null?

713

what is the different between now() and current_date()? : Sql dba

703

How do you rename a table in sql?

735

How do I restart sql?

723

What is execute immediate?

718

what is not null constraint? : Sql dba

721

What are pl/sql cursor exceptions?

755

Is it possible to pass parameters to triggers?

777

What is the use of double ampersand (&&) in sql queries? Give an example

811

What is data control language?

736