Interested to Buy Any Domain ? << Click Here >> for more details...
How many types of Joins in SQL Server 2005?
- 9 Answers
- 11958 Views
- CarrizalSoft Technologies, HCL, I also Faced
- E-Mail Answers
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 |
What is Deadlock?
What command must you use to include the not null constraint after a table has already been created?
How to make a remote connection in a database?
What is the concept of optimization?
What are the different normalization forms?
How do I shrink an ldf file?
What is replication with database mirroring? : sql server database administration
Is sql server free?
How many full-text indexes can a table have?
explain how to create a new schema in a database? : Sql server database administration
What is the difference between stored procedure and user defined functions?
Can we create a clustered index on composite primary key.
-
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)
