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,

---

Explain the concept of view and Types of views in SQL server?

0 Answers   HCL,

---

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

2 Answers   HCL,

---

How to a Query to copy data from on table to another table.

6 Answers   Cap Gemini,

---

What is a full text index?

0 Answers  

---

---

How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

0 Answers   IBM,

---

How many types of triggers in sql server?

0 Answers  

---

How do I find query history in sql server?

0 Answers  

---

Can we execute a stored procedure inside a trigger?

6 Answers   BirlaSoft, CarrizalSoft Technologies, United Healthcare,

---

How to find the date and time of last updated table?

6 Answers   Teledata,

---

employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.

3 Answers  

---

How to find the service pack installed? : sql server database administration

0 Answers  

---