Interested to Buy Any Domain ? << Click Here >> for more details...
How many types of Joins in SQL Server 2005?
- 9 Answers
- 11664 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 |
How reterive duplicate value in SQL?
Can you explain different types of joins?
How would you add a section to a table?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
What is after dml trigger?
Is sql server 2016 free?
What is the use of toad or sqldbx.?
What are the different ways you can create databases in sql server?
Explain powershell included in sql server 2008?
In join, which clause in not used?
how you can list all the tables in a database?
Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?
-
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)
