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

List layers of abstraction microsoft architectured to provide relational db through cloud platform ?

163

---

Explain how to send email from sql database?

577

---

What command would you use to add a column to a table in sql server?

762

---

How much space does sql server 2016 take?

573

---

What is the process of normalising?

604

---

---

What are the key configuration files for sql server reporting services ?

120

---

What is the difference between dropping a database and taking a database offline?

708

---

What are cascading parameters in ssrs reports?

176

---

What objects does the fn_my_permissions function reports on? : sql server security

571

---

Give me a SQL Query to find out the second largest company?

706

---

How do I find my localdb version?

509

---

What is a performance monitor?

566

---

Why functions are used in sql server?

520

---

Explain “not null constraint” in sql server?

532

---

Can you explain what is the use of custom fields in report?

612

---