Answer Posted / g

TO FIND THE 3rd,

select max(sal) from emptable where salary not in(select
distinct top 2 sal from emptable)

TO FIND THE 4th,

select max(sal) from emptable where salary not in(select
distinct top 3 sal from emptable)

TO FIND THE 5th,

select max(sal) from emptable where salary not in(select
distinct top 4 sal from emptable)

keep change top value...

How to see existing views in ms sql server?

1044

---

What are system databases into sql server (2005/2008)?

999

---

Can you explain what are various ways to enhance the ssrs report?

1002

---

Explain boyce and codd normal form(bcnf)?

958

---

What is executereader?

952

---

What is report subscription?

125

---

what is a check constraint?

1122

---

What are transactions in sql?

1061

---

What is a non clustered primary key?

925

---

Tell me what is the stuff and how does it differ from the replace function?

981

---

How to enable/disable indexes?

1068

---

What is the use of @@spid?

1001

---

What is save transaction and save point?

1202

---

What is the command used to check locks in microsoft sql server?

1044

---

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

988

---