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  

---

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,

---

What are the recovery models in sql server 2000?

0 Answers  

---

Where the sql logs gets stored?

0 Answers  

---

Explain the types of indexes.

0 Answers   Accenture,

---

What types of integrity are enforced by a foreign-key constraint

1 Answers  

---

Write a query to delete duplicate records in SQL SERVER

36 Answers   Infosys,

---

what is blocking? : Sql server database administration

0 Answers  

---

What are the two authentication modes in sql server?

0 Answers  

---

Explain Trigger with an example?

2 Answers  

---

Can you explain what are commit and rollback in sql?

0 Answers  

---

create table with fields ID, reserved_by,res_date res_date is datefield like 2010-03-09 00:00:00.000 from 2005 to 2006 any date assume based on res_date need to slect table and display based on month (full jan details in database irrespective of date and year

3 Answers  

---