Join 3 tables (table1, table2 & table3) in a single query. Inner join should be applied for table1 & table 2 and left outer join for table1 & table3 where table2.dept is ABC

2 Answers  

---

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  

---

What is the difference between the 2 operating modes of database mirroring?

0 Answers  

---

what are the joins,primary key,foriegn key, candidate key, super key and expain them?

6 Answers   Polaris,

---

How will you decide the active and passive nodes?

0 Answers  

---

Define right outer join in sql server joins?

0 Answers  

---

what is an extended stored procedure? : Sql server database administration

0 Answers  

---

What is 5nf in normalization form?

0 Answers  

---

What are sp_configure commands and set commands?

0 Answers  

---

Why transaction is important?

0 Answers  

---

What do you understand by intent locks?

0 Answers  

---

What is the difference between distinct clause and group by clause?

2 Answers   HHH, Value Labs,

---