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

Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query

3 Answers   RND Soft, Wipro,

---

Why do you want to join software field as you have done your BE in Electronics?

1 Answers   Cap Gemini, HCL,

---

How will you go about resolving deadlocks?

1 Answers  

---

Which institute is best for SQL Server 2005 Training?

6 Answers  

---

How can you set the threshold at which sql server will generate keysets asynchronously?

1 Answers  

---

Mention the differences between local and global temporary tables.

1 Answers  

---

how to give input dynamically to a insert statement in sqlserver

3 Answers   HCL,

---

How to find out what is the default collation in a database?

1 Answers  

---

You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

1 Answers  

---

Explain what are db_options used for?

1 Answers   InterGraph,

---

When do we use the UPDATE_STATISTICS command?

4 Answers   Deutsche Telekom AG,

---

Can you pass expressions to stored procedure parameters?

1 Answers  

---