How many types of Joins in SQL Server 2005?
Answers were Sorted based on User's Feedback
Answer / prasanna
1.Inner Join
- Equi Join
- Natural Join
2.Outer Join
- Left Outer Join Or Left Join
- Right Outer Join Or Right Join
- Full Outer Join Or Full Join
3.Cross Join
4.Self Join
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / mpg
There are 5 types of join in sql server 2005
inner join
outer join
cross join
equi join
self join
| Is This Answer Correct ? | 6 Yes | 3 No |
Answer / rupinder kaur
there are five types:
inner join
outer join: left outer join,right outer join, full outer
join
equi join
cross join self join
| Is This Answer Correct ? | 5 Yes | 2 No |
Answer / kalyana chakravarthy maddipati
Apart all the joins above there is one more join it is
NO EQUI JOIN ie emp.deptno!= dept.deptno or one can use <> sign instead
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / vishal
1. Inner Join
2. Outer Join
- Left Outer Join
- Right Outer Join
- Full Outer Join
3. Cross Join
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / abi
Types of Joins
1.Inner Join
2.Outer Join
-- Left Outer Join
-- Right Outer Join
-- Full Outer Join
3.Self Join
4.Cross Join
5.Equi-Join
6.Cross Apply Join
7.Outer Apply Join
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / kittu
inner join
outer join
cross join
equi join
self join
| Is This Answer Correct ? | 1 Yes | 2 No |
Explain the rules for designing files and file groups in sql server?
which one will take 1st priority in case of insert statement and select statement???
What do you understand by recursive stored procedure?
Write a code to select distinct records without using the DISTINCT keyword.
Explain about SQL server 2005?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
What are null values in ms sql server?
How to select top 5 coloumn from a table without using coloumn name
Define outer join?
List the various tools available for performance tuning?
Explain the dbcc pintable command when would you use it?
how to find the second salary?
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)