Answer Posted / balindra sahani

select max(salary) from table_name where max(salary)not
in(select top(n) from table_name order by salary asc)

where n=nth number salary

What is the difference between for trigger and after trigger?

1163

---

Mention what are the core components of ssrs?

330

---

Can you explain full-text query in sql server?

1059

---

what is a self join? Explain it with an example? : Sql server database administration

1002

---

What is the purpose of a table?

997

---

Explain steps of normalization?

1067

---

What is merge statement?

1136

---

Tell me what is the order in which the sql query is executed?

1018

---

mention different types of relationships in the dbms?

1092

---

Explain how you can deploy an SSRS report?

156

---

What is difference between drop truncate and delete?

1157

---

Distinguish between nested subquery and correlated subquery?

1115

---

Explain how many types of relationship?

1086

---

What is catalog views?

1122

---

Explain about local stored procedure?

1031

---