Interested to Buy Any Domain ? << Click Here >> for more details...
How many types of Joins in SQL Server 2005?
- 9 Answers
- 12226 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 to convert numeric expression data types by assignment operations?
When do u use clustered index and non-clustered index?
What are the types of constraints?
Is null vs coalesce?
What are the types of resultset?
About types of indexes in SQL server ?
What are cursors in ms sql server?
What new changes are being made in SQL Server?
What is the difference between ‘having’ clause and a ‘where’ clause?
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
How to list all triggers in the database with sys.triggers in ms sql server?
What is normalization and denormalization in sql server?
-
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)
