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

Does sql full backup truncate logs?

1080

how to enter characters as hex numbers? : Sql dba

1102

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

1017

What is varchar data type in sql?

1138

What is pivot query?

1122

how to get @@error and @@rowcount at the same time? : Sql dba

1082

Explain how can you save or place your msg in a table?

1076

How to display the records between two range in Oracle SQL Plus?

1195

What is the difference between sum and count in sql?

1039

Which sql statement is used to delete data from a database?

1007

what is myisam? : Sql dba

1160

what is sql profiler? : Sql dba

1115

What is use of package in pl sql?

1070

Explain alias in sql?

1094

How do I use google cloud in sql?

1146