Answer Posted / dewashish kumar pal

select salary from tablename t where (n-1)= (select count(*) from tablename where salary > t.salary);


note:- t = tablename

Are resultset updatable?

1010

---

What are data regions?

140

---

Will the writetext statement activate a trigger?

1156

---

How many replicas are maintained for each sql azure db?

124

---

List down some advantages of sql stored procedure?

1016

---

How to specify the collation for a character data type in ms sql server?

1089

---

Explain full-text indexing?

1045

---

How to invoke a trigger on demand?

1153

---

as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

952

---

How many types of stored procedures are there in sql server?

1060

---

What do you understand by check constraint in sql server?

1019

---

How to disable stored procedure sql server?

1671

---

How do I setup a sql server database?

1129

---

Explain how you can deploy an SSRS report?

156

---

What are the steps you should follow to start sql server in single-user mode?

954

---