Select * from emp where sal in (Select * From (Select sal from emp order b

i need department wise top 2 employees salary.which logic
i will use

Question Posted / ramya p

Answer Posted / ramya p

Select * from emp where sal in
(Select * From (Select sal from emp order by sal desc)
Where rownum < 3) order by sal desc;

Is This Answer Correct ?

6 Yes

18 No

Please Help Members By Posting Answers For Below Questions

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

1074

Explain the structure of pl/sql in brief.

1044

What is scalar function?

1002

What is sql analyzer?

962

Mention what does plv msg allows you to do?

1054

What is oracle pl sql developer?

936

what is transaction? : Sql dba

961

Which command is used to call a stored procedure?

954

what is the bond code in materialized view?

2933

Explain unique key in sql.

944

What is raw datatype in sql?

982

What are the benefits of pl/sql packages?

1035

What are the types of views in sql?

1041

What is multiple columns?

1002

Is not equal in sql?

960