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 a primary key? : Sql dba

1086

what is the difference between union and union all? : Sql dba

1068

Write the alter statement to enable all the triggers on the t.students table.

1175

Can a composite key be null?

1034

what is a cursor? : Sql dba

1066

What is the file extension for sql database?

1063

Explain the difference between rename and alias?

1068

Can we use having without group by in sql?

1051

What is rtm in testing?

1175

What are the disadvantages of not performing database normalization?

1216

What is pessimistic concurrency control? : Transact sql

1135

Why do we need view in sql?

1039

What is dense_rank?

989

Can a varchar be a primary key?

1049

What are basic techniques of indexing?

1441