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 prepared statement in sql?

998

How delete all data from all tables in sql?

887

What are different methods to trace the pl/sql code?

1050

Name the different types of indexes in sql and define them.

1077

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

940

what are ddl statements in mysql? : Sql dba

1114

Can we join more than 2 tables in sql?

950

what is a database lock ? : Sql dba

1093

What is application trigger?

947

What is the use of function in sql?

1029

How to run sql*plus commands in sql developer?

1086

what are the authentication modes in sql server? : Sql dba

1000

What is an alias command?

1007

What is range partitioning?

913

what is a control file ? : Sql dba

991