what is the difference between group and having give an example with query and sample output

7 Answers  

---

Is foreign key unique?

0 Answers  

---

Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500

14 Answers  

---

What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123) WHAT IS THE DIFFERENCE?

15 Answers   Adsys, Cap Gemini,

---

Explain cross join or cartesian product in sql?

0 Answers  

---

---

What is the purpose of indexing?

0 Answers  

---

Please explain go command in sql server?

0 Answers  

---

What do you understand by hotfixes and patches in sql server?

0 Answers  

---

What are audit control procedures?

0 Answers   Ernst Young, Thomson Reuters,

---

Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

0 Answers  

---

Can you give an example of Stored Procedure?

4 Answers   Wipro,

---

What is the default port for SQL Server over a firewall?

0 Answers   Microsoft,

---