Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


Can you explain the types of Joins that we can have with Sql
Server?

Answers were Sorted based on User's Feedback



Can you explain the types of Joins that we can have with Sql Server?..

Answer / guest

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

Is This Answer Correct ?    5 Yes 0 No

Can you explain the types of Joins that we can have with Sql Server?..

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.

Is This Answer Correct ?    6 Yes 1 No

Post New Answer

More SQL Server Interview Questions

Why should one not prefix user stored procedures with ‘sp_’?

0 Answers  


Does transparent data encryption provide encryption when transmitting data across the network?

0 Answers  


What is the difference between NOROW and LOCKROW?

0 Answers   Accenture, Honeywell, Satyam,


Explain Trigger with an example?

2 Answers  


What are different types of constraints?

0 Answers  


Which is the latest version of sql server and when it is released?

0 Answers  


How to list all objects in a given schema?

0 Answers  


What types of replication are supported in sql server?

0 Answers  


What are indexes in ms sql server?

0 Answers  


Can multiple columns be used in sql group by clause in ms sql server?

0 Answers  


What is best institute to Learn DotNET And SQL in chennai?

0 Answers  


What are the different methods available under sqlcommand class to access the data?

0 Answers   UGC Corporation,


Categories