Answer Posted / debasish

select salary from table t where n-1=(select distinct count
(sal) from table t1 where t1.sal>t.sal)

What are subquery and its properties?

568

---

How to use subqueries with the in operators in ms sql server?

554

---

What does COMMIT command do?

620

---

Which is the best place or learning center for MS SQL?????In Bangladesh?????

1586

---

Explain throw statement in sql server 2008?

577

---

---

What are the limitations/drawbacks or ssrs 2008 r2?

86

---

What structure can you implement for the database to speed up table reads?

701

---

How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

540

---

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

532

---

How to convert a numeric expression from one data type to another?

491

---

List out some of the requirements to set up a sql server failover cluster?

539

---

How to provide default values to function parameters?

587

---

What are the advantages of stored procedure in sql server?

458

---

How to name query output columns in ms sql server?

531

---

What do you understand by mirroring?

558

---