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 is clause in sql?

1108

What is meant by cursor in sql?

997

What is a record in a database?

1062

What is the usage of when clause in trigger?

1055

How bulk collect improves performance?

1002

Do stored procedures prevent sql injection?

966

What is the use of index in sql?

1017

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

1442

How many commands are in sql?

1068

What is scalar function in sql?

1038

tell us something about heap tables. : Sql dba

1098

what is the difference between nested subquery and correlated subquery?

1053

What is a full join?

981

Does asenumerable execute the query?

1043

how can we repair a mysql table? : Sql dba

979