Answer Posted / dilip

SELECT MIN(SALARY) FROM tablealies.Table_Name WHERE SALARY
IN (SELECT DISTINCT TOP N MAX(SALARY) FROM
tablealies.Table_Name ORDER BY SALARY DESC)

What is 5nf in normalization form?

647

---

What is Extended user-defined?

625

---

Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

615

---

How to list all schemas in a database?

669

---

What are the different authentication modes in sql server?

709

---

---

Define synonym?

804

---

What encryption security is available in sql azure?

85

---

How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

693

---

What is a functions and types in sql server?

662

---

What happens if null values are involved in datetime operations?

609

---

What are parameterized reports?

168

---

Distinguish between nested subquery and correlated subquery?

634

---

Explain indexes disadvantages?

633

---

Can we do dml on views?

643

---

ow to bring suspect mode datbase online from scratch

1497

---