Answer Posted / shiva

SELECT MAX( salary) FROM salary where salary not in(
SELECT DISTINCT TOP 3 salary FROM salary order by salary desc)

What is instead of dml trigger?

587

---

How many types of built in functions are there in sql server 2012?

490

---

What are data regions?

92

---

What is the difference between clustered and non-clustered indexes in ms sql server?

491

---

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

504

---

---

How to get a list of all tables with "sys.tables" view in ms sql server?

551

---

Explain the xml support sql server extends?

623

---

Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture

494

---

What is table level trigger?

584

---

Define Wed Edition in SQL Azure?

80

---

What is a trace frag?

644

---

what is spatial nonclustered index

546

---

How to delete an existing row with delete statements in ms sql server?

552

---

What is policy based management (pbm)? : sql server database administration

585

---

How to view the error log for any specific instance? : sql server database administration

581

---