how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

0 Answers   Facebook,

---

Do you know what is normalization of database? What are its benefits?

0 Answers  

---

What are the steps you will take to improve performance of a poor performing query?

1 Answers  

---

What is 4nf in normalization form?

0 Answers  

---

What is check constraint in sql server?

0 Answers  

---

---

What is sql sandbox in sql server?

0 Answers  

---

what is web server?

3 Answers   Satyam,

---

What is the difference between truncate and delete commands?

0 Answers  

---

What is a select query statement in ms sql server?

0 Answers  

---

What is a materialized view?

3 Answers  

---

Can we call a function that has out parameter in select statement

0 Answers   Nagarro,

---

Are null values the same as that of zero or a blank space?

0 Answers  

---