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 are the disadvantages of mysql? : Sql dba

1075

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

7134

When are we going to use truncate and delete?

925

What is query syntax?

912

what is unique key constraint? : Sql dba

991

What kind of join is join?

903

What is procedure explain with program?

949

What is mutating error?

907

What is difference between sql and mysql?

1064

what is difference between delete and truncate commands? : Sql dba

1065

how to convert numeric values to character strings? : Sql dba

1035

What is sql select statement?

968

Does a join table need a primary key?

902

What is the benefit of foreign key?

960

What is schema in sql example?

1088