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 to check myisam tables for errors? : Sql dba

1304

What are sql functions? Describe the different types of sql functions?

1119

How can a function retun more than one value in oracle with proper example?

1061

What is the purpose of a sql?

961

what is timestamp in mysql? : Sql dba

1047

Is it possible for a table to have more than one foreign key?

1016

How subquery works in sql?

1052

What is cost in sql execution plan?

962

What is sql partition function?

1183

What are triggers and its types?

1041

What is a rank in sql?

940

What is the starting oracle error number? What is meant by forward declaration in functions?

971

Why is a trigger used?

925

what is 'mysqladmin' in mysql? : Sql dba

1009

What is the trigger in sql?

929