Interested to Buy Any Domain ? << Click Here >> for more details...
Can you explain the types of Joins that we can have with Sql
Server?
- 2 Answers
- 6518 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
Can two tables have the same primary key?
What is Command line parameters in PLSQL.?
What are a scheduled jobs?
What is normalization of database? What are its benefits?
How to create median function?
Do you know the isolation level that sql server support?
What do you mean by subquery?
How to find the second highest salary of an employee?
What are basics of policy management?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
How to restore performance issues and how to check?
Explain the truncate command? : SQL Server Architecture
What is the use of “join” in sql server?
What are joins in sql and what are the different types of joins?
