Answer Posted / dewashish kumar pal

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


note:- t = tablename

what stored procedure can you use to display the current processes? : Sql server administration

1008

---

What are the benefits of normalization?

1109

---

Explain different types of lock modes in sql server 2000?

931

---

Do you know exporting and importing utility?

1039

---

What is BLOCK statements in SQL?

1263

---

Is null vs coalesce?

882

---

How do you set a trace flag in sql server?

1035

---

Tell me what is the significance of null value and why should we avoid permitting null values?

983

---

Explain the steps to use transact-sql cursor?

1061

---

Explain about link server in sql server?

1055

---

What is a raid and what are different types of raid configurations?

1267

---

Mention the 3 ways to get a count of the number of records in a table.

976

---

What to check if a User database is locked?

1069

---

Is port 1433 secure?

997

---

Tell me about joins in database system and explain each in detail.

1046

---