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 schema? : Sql dba

1026

What is input buffer in sql*plus?

1193

Explain about various levels of constraint.

921

What is linq to sql?

1120

why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

1094

What is nvarchar max in sql?

994

List and explain the different types of join clauses supported in ansi-standard sql?

1345

Explain polymorphism in pl/sql.

1096

What is sql select statement?

1014

What is the trigger in sql?

930

What is query execution plan in sql?

1167

What is the difference between database trigger and stored procedure?

1059

What is a parameter query?

1059

How do you update a sql procedure?

1012

What are the two parts of design view?

1004