Answer Posted / guru

select max(salary) from Employee where salary not in(select
top (n-1) salary from Employee order by salary desc)

Is it possible to create trigger on views?

981

---

What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

1263

---

What the difference between UNION and UNIONALL?

1040

---

What is a Join and explain its types?

1103

---

What is a join in sql?

1092

---

How to round a numeric value to a specific precision?

1074

---

What is sqlcmd?

1047

---

What is provisioning, billing and metering, and connection routing concepts in the service layer?

113

---

What are different backups available in sql server?

1070

---

Explain about protocol layer present in SQL server?

1199

---

How to enter unicode character string literals in ms sql server?

1072

---

Tell me what is the significance of null value and why should we avoid permitting null values?

984

---

What is attribute? : sql server analysis services, ssas

1018

---

A trigger can reference objects outside the current database? State true or false.

1006

---

What is table level trigger?

1020

---