What is Inner Join?
Answers were Sorted based on User's Feedback
Answer / g.ramesh
Inner Join is default type of join.
It produce result set, which contain's only matched rows.
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / prasanna
Inner joins use a comparison operator(like = or <>)to match
rows from two tables based on the values in common columns
from each table.It is a default type of join.
These includes Equi Joins and Natural Joins.
| Is This Answer Correct ? | 0 Yes | 1 No |
Explain Active/Active and Active/Passive cluster configurations
What is onf in normalization form?
What are the different SQL Server Versions you have worked on?
What is the Query of getting last 10 transaction Reports (like insert, update, Delete Data from Tabele) ?
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?
How to add more data to the testing table in ms sql server?
How to override dml statements with triggers?
What is sleeping status in sql server?
What is rank function?
What are the differences between decimal and float in ms sql server?
Explain the functionalities that views support?
What command must you use to include the not null constraint after a table has already been created?
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)