What is the benefit of normalization?

0 Answers  

---

In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;

5 Answers   Infosys,

---

How you can change a cross join into an inner join?

0 Answers  

---

Tell me when is the update_statistics command used?

0 Answers  

---

Explain what is analysis service repository?

0 Answers  

---

Hi Friends, I have a table in which there are thousands of records and in city field there is NULL value for all records now i want to change that null value with distinct values in each record say delhi, bihar, agra, jaipur etc, what will be the query for that????? its not possible to update thousands of records one by one. is there any alternative ...? Plz help ... its urgent Thanx in advance

1 Answers  

---

how to write the query to select the rows are in the order of either 1,3,5,7... or 2,4,6,8,...

7 Answers   ADP, Satyam, Tech Mahindra,

---

which backup strategy you are following at ur company

0 Answers  

---

What is a View ? Can we insert, Update and delete a view?

0 Answers   Arigo Infotech,

---

What is correlated subquery in sql server?

0 Answers  

---

What is difference between rownum and rowid?

0 Answers  

---

What is normalization in Database ?

4 Answers  

---