Answer / g.ramesh

It produce Result Set Which contains matched rows and right
table unmatched rows.

Answer / ram

select empno,ename,sal,e.deptno,dname from emp e right outer
join dept d where e.deptno=d.deptno

in abvoe query we use emp and dept table with right outer join
which produce output all records from dept table and
matched records from emp table

Tell me about the approaches which you used to counter the DI problems.

0 Answers   EXL,

---

What is optimization and its types?

0 Answers  

---

How to get number of days in a given year?

4 Answers   ADP,

---

How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?

1 Answers  

---

What is the maximum number of instances in 32 bit and 64 bit sql server 2012?

0 Answers  

---

---

What is the difference between delete and truncate statements?

0 Answers  

---

About types of indexes in SQL server ?

2 Answers   Cognizant,

---

We create an index to fast the search. How it fast the query? Do we write any special keyword with query?

3 Answers  

---

Explain different types of locks in sql server.

0 Answers  

---

Diffrences between sql server 2000 vs 2005

2 Answers   Thomson Reuters,

---

What is advantage data architect?

0 Answers  

---

select the 3rd maximum salary from sql server database if 4 (just an example In practically I may not know the exact situation) of the highest salaries are equal.

8 Answers   TCS,

---