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

1117

How sql query is executed?

1187

Explain what is dbms?

1119

What is sqlerrd?

1015

What are the parts of a sql statement?

1143

What is an exception in pl/sql?

1161

What is the unique index?

1108

Why is pl sql needed?

1004

How do you determine the current isolation level? : Transact sql

1203

What is sorting in sql?

983

What is query optimization in sql?

1040

what are enums used for in mysql? : Sql dba

1228

Is primary key is clustered index?

1042

What is trigger in pl sql with examples?

1080

What is the difference between clustered and non-clustered index in sql?

1065