Answer / dhanasekaran

select *
from table1 t1
inner join table2 t2 on t1.key = t2.key
left outer join table3 t3 on t1.key = t3.key
where t2.dept ='ABC'

Answer / sumit m.

Although the above answer is correct. I am preferring
paranthesis in the answer, something like below:

There are 2 forms of the query for the answer:

SELECT *
FROM (table t1 INNER JOIN table2 t2 ON t1.col = t2.col AND
t2.dept = 'ABC')
LEFT JOIN table t3 ON t1.col = t3.col

OR

SELECT *
FROM (table t1 INNER JOIN (SELECT * FROM table2 WHERE dept
= 'ABC') t2 ON t1.col = t2.col)
LEFT JOIN table t3 ON t1.col = t3.col

What is the difference between Temporary table variable and a Table variable? Or Which Table variable I should use inside Stored procedure?

3 Answers   Microsoft, TCS, Techastrum,

---

What is the full form of dql?

0 Answers  

---

Explain what are the events recorded in a transaction log?

0 Answers  

---

What is the return type of executeupdate ()?

0 Answers  

---

Do you know what is openxml in sql server?

0 Answers  

---

Tell me what are the advantages of using stored procedures?

0 Answers  

---

What happens if ntwdblib.dll is missing on your machine?

0 Answers  

---

Explain throw statement in sql server 2008?

0 Answers  

---

What is self contained scalar sub query?

0 Answers  

---

In join, which clause in not used?

4 Answers   HCL, NIIT, TCS,

---

what is hash nonclustered index

0 Answers  

---

What is repeatable read?

0 Answers  

---