Can you explain the types of Joins that we can have with Sql
Server?
Answers were Sorted based on User's Feedback
Answer / guest
There are three types of joins: Inner Join, Outer Join,
Cross Join
| Is This Answer Correct ? | 5 Yes | 0 No |
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 |
How do you delete duplicate records in sql server?
Explain how does the report manager work in ssrs?
How to loop through result set objects using mssql_fetch_array()?
What is the difference between Temporary table variable and a Table variable? Or Which Table variable I should use inside Stored procedure?
3 Answers Microsoft, TCS, Techastrum,
What are the four main query statements?
What is set nocount on and what is set nocount off?
What is an indexing technique?
Do you know what are the properties of the relational tables?
Write a SQL query to delete a table?
What are the different ways of moving data/databases between servers and databases in SQL Server?
How to Handle the exceptions in Sqlsrver 2005??
Are resultset updatable?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)