Answer / guest

There are three types of joins: Inner Join, Outer Join,
Cross Join

Answer / hokar

In some situations we may need to pull data from one or
more related tables at a time. In such cases we use JOINs
to extract data from more than one table at a time and
display the information in a single result set.
There are several types of joins.(1)Inner Join
(2)Outer
Join------Right Outer Join,Left Outer Join, Full Outer Join
Inner join is used to link tables on a common column and
return records that match in those columns.
Right Outer Join displays all records from the table on
right most side of the JOIN clause whether or not there are
matching records in the Left table.
Left Outer Join displays all records from the table on the
left most side of the JOIN clause whether or not there are
matching records on the Right table.
Full Outer Join diplays all records from both right and
left tables.
Example: If we have a HR database with employee information
table, salary information table, sick days table etc, and
if we want to know which employee
have used more than 15 sick days, we would need the
information form sick days table and employee information
table in a single result set.

How to provide column names in insert statements in ms sql server?

0 Answers  

---

How do I change my passwords (database, LDAP, and so on) without causing an outage?

0 Answers   IBM,

---

What are SQL Jobs, please mention the use of it and how to create them.

1 Answers   247Customer,

---

What is log cache in sql server?

0 Answers  

---

How can sql server instances be hidden?

0 Answers  

---

Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

0 Answers  

---

How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

0 Answers  

---

What is etl - extraction, transformation, and loading?

0 Answers  

---

in tabase table having a column in it empname field is there which having 5 duplicate values is there i want deleted all the duplicates i want showing only one name only.

7 Answers  

---

what is the Surrogate key?and wt is the diff between Primary key and Surrogate Key?

2 Answers  

---

Can anyone explain difference between Database, Data warehouse and Data mart with some example?````

4 Answers  

---

How check triggers in sql server?

0 Answers  

---