Select top(2)* from table order by salary desc

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

Question Posted / arun

Answer Posted / arun

Is This Answer Correct ?

2 Yes

7 No

Please Help Members By Posting Answers For Below Questions

What are local and global Indexes and where they are useful.

1377

What is the difference between function, procedure and package in pl/sql?

1132

How many sql databases can you have on one server?

1016

what is a constraint? : Sql dba

1101

Which command is used to call a stored procedure?

949

What is a dirty read sql?

1029

What is bulk collect in pl sql?

1015

Is it possible to include an insert statement on the same table to which the trigger is assigned?

955

What are different types of queries in sql?

1043

How do you respond to dementia behavior?

922

Can a composite key be null?

905

What is group by in sql?

1021

Why do we use view in sql?

907

What are the different sql languages?

984

what are myisam tables? : Sql dba

946