Answer Posted / krish

select max(sal) frem tbl where sal <(select max(sal) from tbl;

What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

966

---

What is difference between delete and truncate commands?

997

---

Give an example of why you would want to denormalize a database

927

---

Explain the third normal form(3nf)?

896

---

Introduction of rollup clause using sum and group by clause?

901

---

What are different types of database indexes?

1014

---

What is side by side migration in sql server?

1023

---

When cursors are useful?

1038

---

Explain about SQLOS?

948

---

What are the benefits of normalization?

1044

---

How to execute a stored procedure in ms sql server?

1071

---

How can I add Reporting Services reports to my application?

125

---

How to use “drop” keyword in sql server and give an example?

1091

---

What is difference between primary key and foreign key?

836

---

what is a transaction? : Sql server database administration

935

---