Answer Posted / amit kumar

--- Getting 4th highest salary
--- 4 can be replaced with any number

with EmpSal as
(Select *, row_number() over (order by EmpSal Desc)
as 'rownumber' from employee)

Select * from EmpSal where rownumber =4

Why I have to use stored procedures?

1061

---

How can you tell if a database object is invalid?

1080

---

What is a natural primary key?

1057

---

What are difference between Cluster index and Non-Cluster index?

1086

---

What are the difficulties faced in cube development? : sql server analysis services, ssas

1051

---

How to query multiple tables jointly?

997

---

IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

1808

---

What is a bit datatype?

993

---

Explain tablesample?

1005

---

What is the difference between dropping a database and taking a database offline?

1178

---

What are the differences between clustered and non-clustered index?

1037

---

What are partitioned views?

1010

---

Can you explain about buffer cash and log cache in sql server?

957

---

Why can there be only one clustered index and not more than one?

1009

---

Explain what stored procedure sp_replcounters is used for? : sql server replication

1527

---