SELECT * FROM (SELECT ENAME,SAL FROM EMP ORDER BY SAL DESC) WHERE ROWN

i need department wise top 2 employees salary.which logic
i will use

Question Posted / priyank shah

Answer Posted / priyank shah

SELECT * FROM (SELECT ENAME,SAL FROM EMP ORDER BY SAL
DESC)
WHERE ROWNUM < 3

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is a full join?

996

Does sql*plus have a pl/sql engine?

1078

what is meant by nl2br()? : Sql dba

1051

Why is sql important?

1115

How can you know that statistics should be updated?

1081

Why we use sql profiler?

963

What is substitution variable in pl sql?

1051

What are procedures used for?

991

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

1027

Sql technical questions

1288

What is acid property in a database?

1037

What does an inner join do?

1192

What is difference between inner join and self join?

1090

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

1024

Explain the uses of a database trigger?

1045