Answer Posted / shiva

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

Explain what is the function of sql server agent windows service?

1044

---

How do I find my localdb version?

1030

---

Does the unique constraint create an index?

1137

---

What is use of attribute hierarchy ordered ? : sql server analysis services, ssas

1058

---

Explain what are partitioned views and distributed partitioned views?

1019

---

How to stop log file growing too big?

1064

---

How to list all tables in the database using odbc_tables()?

1120

---

What is 2nf normalization form?

1204

---

What are the advantages dts has over bcp?

1051

---

What is autocommit mode in sql server?

1269

---

How to provide default values to function parameters?

1224

---

Explain different types of collation sensitivity?

1032

---

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

1066

---

What is the difference between row_number and dense_rank?

937

---

What are different types of data sources?

1085

---