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 |
How do you use DBCC statements to monitor various aspects of a SQL server installation?
Difference between rowid and rownum in SQL?
What is the appropriate number of test cases that you can write on a database?
What do you understand by physical_only option in dbcc checkdb?
What is postgresql server?
What is the use of toad or sqldbx.?
Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security
How do I run a trace in sql server?
How can count the string ? for ex: If i have string like 'bhaskar' then i need like b:1 h:1 a:2 s:1 k:1 r:1 please give any idea on that
How to drop an existing stored procedure in ms sql server?
How to insert a new row into a table with "insert into" statements in ms sql server?
What stored by the master?
Oracle (3253)
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)