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,

---

What is data compression? : sql server database administration

0 Answers  

---

what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

0 Answers  

---

How to insert data into an existing table?

0 Answers  

---

Write the queries for commands like Create Table, Delete table, Drop Table etc.

0 Answers   HPCL, Hughes Systique Corporation,

---

What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers   HCL,

---

Explain error handling in ssis?

0 Answers  

---

can a database be shrunk to 0 bytes, if not, why? : Sql server administration

0 Answers  

---

What happens on checkpoint?

0 Answers  

---

What is a mutating table error and how can you get around it?

0 Answers  

---

Explain Different types of Projects?

1 Answers  

---

can any one answer this query,thank you in advance Table 1 has 2 columns: EmployeeId, T shirtsize(values can be 1,2,3) Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region which has the largest number of people with Tshirt size=3

15 Answers   Google,

---