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 different tables present in mysql? : Sql dba

678

When do we use triggers?

800

What is a system versioned table?

702

How do I add a database to sql?

777

What is a pl/sql block?

759

what is the functionality of the function htmlentities? : Sql dba

694

What is bind variable in pl sql?

723

What are user defined functions?

759

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

942

How do you declare a user-defined exception?

718

What is the sql query to display the current date?

758

Explain about various levels of constraint.

702

What is a temporal data type?

773

Is hadoop a nosql?

745

What does the hierarchical profiler does?

755