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 the difference between ereg_replace() and eregi_replace()? : Sql dba

558

Differentiate pl/sql and sql?

565

What is dynamic query?

543

What are functions in sql?

513

Is sql procedural language?

556

What is composite primary key in sql?

524

How to run sql*plus commands in sql developer?

592

Can I join the same table twice?

529

what are date and time data types in mysql? : Sql dba

504

Is sql better than excel?

519

What is a pdo connection?

520

Does sql*plus also have a pl/sql engine?

563

What is the difference between rename and alias?

713

What is ttitle and btitle?

579

What is the command used to fetch the first 5 characters of a string?

713