Types of joins?
Answers were Sorted based on User's Feedback
Answer / sangeetha meda
1. Self Join
Self join is a query in which a table is Joined to itself.
Self joins are used to compare the values in a column to
the other values in the same column in the same table.
2.Equi Join or Inner join
Equi join is a join in which the rows are retrieved the
equality of the relation ship between columns in the tables.
Select only those rows that have values in common in the
columns specified in the ON clause.
3.Non Equi Join or Outer Join
Left Outer Join:
Retrieves the matching records in both the table and non
matching records in the first or left table.
Right Outer Join
retrieves the matching records in both the table and non
matching records in the second or the right table.
Full Outer Join
Retrieves all the records (means matching and non matching
records in both the tables).
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / deeksha
4 types
1.equijoin
2.non-equijoin
3.self join
4.outer join
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / mohana sundaram
self joins,natural joins,cross joins,inner joins,outer
joins,equi and nonequi joins.
| Is This Answer Correct ? | 2 Yes | 0 No |
(1) Inner or Equei join
(2) Outer or no - equei join
(a) left outer
(b) right outer
(c) full outer
(3) Cartision or cross join
(4) Self join
(5) Natural join
| Is This Answer Correct ? | 2 Yes | 0 No |
Explain what is a field in a database and record in a database?
What is index example?
real time applications of nullif?
What is the use of function in sql?
What is a constraint? Tell me about its various levels.
Write a query to find second highest salary of an employee.
What are conditional predicates?
What is a delimiter in sas?
what are the differences between char and varchar? : Sql dba
what are the nonstandard string types? : Sql dba
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
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)