How to apply filtering criteria at group level with the having clause in ms sql server?

0 Answers  

---

When columns are added to existing tables, what do they initially contain?

0 Answers  

---

Please give me queries for the following 1. To get the count of duplicate records. 2. A query to delete the duplicate records.

3 Answers   247Customer,

---

Hi Can any one tell me the Good institute to learn SQL esp for Data Base Testing or SQL from scratch to the proficiency level in Hyederabad and facult also. Thankyou well in advance

6 Answers  

---

What are the two virtual tables SQL Server maintains for triggers?

3 Answers  

---

What is updatable resultset?

0 Answers  

---

hi, how to match retrieve the unmatched records from 2 tables in which we dont have any primary key. example : table1 has 1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want the numbers from 6 to 10 to be displayed and should not come as null. i need the numbers. please reply as soon as possible.

4 Answers  

---

Different types of keys in SQL?

0 Answers   Infosys,

---

What is not null constraint?

0 Answers  

---

What does sql server mean?

0 Answers  

---

What are the magic tables in SQL Server 2000?

7 Answers   Infogain, Merrill Lynch,

---

How to create a dml trigger using create trigger statements?

0 Answers  

---