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 rollback? : Sql dba

1115

What types of commands can be executed in sql*plus?

1111

what is a constraint? Tell me about its various levels. : Sql dba

993

Does a primary key have to be a number?

969

What is varchar example?

1039

What is pessimistic concurrency control? : Transact sql

1094

What is the process of copying data from table a to table b?

1093

What is the main difference between sql and pl/sql?

1104

What is a behavioral trigger?

980

Does sql profiler affect performance?

1000

What is sql lookup?

929

What is the difference between row level and statement level trigger?

1027

What is varray in pl sql?

1082

Does pl sql work in mysql?

987

What is a primary key sql?

1047