Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different types of joins and what does each do?
- 2 Answers
- 8109 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / swapna
Different types of joins are normal joins and set joins.
Normal joins are outer joins and inner joins.
Inner joins are cross join,equi join,non-equi joins,self
joins.
Outer joins are left outer join,right outer join,full outer
joins.
Set joins are union,union all,intersect,minus.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / sachin patil
Diff types of join
1. Inner
2.Left Outer
3.Right Outer
4.Cartesian
5.Self Join
| Is This Answer Correct ? | 2 Yes | 0 No |
Explain what is the difference between a local and a global temporary table?
What is store procedure? When do you use?
What do you understand by recursive stored procedure?
What is Online Index Rebuild Operation?
How can we write or define DDL statements in Sql server and DML statements?
what is the difference between group and having give an example with query and sample output
What are the basic functions for master, msdb, model, tempdb databases?
How make remote connection in database?
How to write a query with a right outer join in ms sql server?
How to provide column names in insert statements in ms sql server?
What are all new concepts in SQL Server 2008? That is Exactly Difference between 2005 to 2008
What is sorting and what is the difference between sorting and clustered indexes?
-
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)
