What is a join and their types?
Answers were Sorted based on User's Feedback
Answer / s.chithiravelu
Join can be defined as an operation that includes the
retrieval of data from more than one table at a time.
Various Types of Joins:
Inner Joins
Outer Joins
Cross Joins
Equi Joins
Natural Joins
Self Joins
| Is This Answer Correct ? | 4 Yes | 0 No |
What the different components in replication and what is their use?
what is a check constraint?
what are the new features introduced in sql server 2000? : Sql server database administration
Can you move the resources after pausing the node? : sql server database administration
Can you use order by when defining a view?
optimization techinques
Join 3 tables (table1, table2 & table3) in a single query. Inner join should be applied for table1 & table 2 and left outer join for table1 & table3 where table2.dept is ABC
How do you rebuild an identity column?
what is raid? : Sql server database administration
Write a program to fetch first 10 records from a file?
Where can you add custom error messages to sql server?
Explain the xml support sql server extends?
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)