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 mysql support pl sql?

1145

What are the types of index in sql?

1053

Is there a 64 bit version of ssms?

947

what are the features and advantages of object-oriented programming? : Sql dba

989

What are the parts of a sql statement?

1072

How can you fetch common records from two tables?

1051

what is 'mysqlcheck'? : Sql dba

995

What is nested table in pl sql?

1053

Why is sql important?

1090

What is pl sql and why it is used for?

1100

How to avoid using cursors?

1102

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

1038

What is pl/sql language case sensitive?

1105

Does access use sql?

1018

What is thread join () in threading?

1001