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 |
What is buffer cash in sql server?
What are different types of data sources?
How to find 6th highest salary from Employee table ?
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
Mention the differences between having and where clause.
Tell me about normalization in DBMS.
Why are views required in the sql server or in any other database?
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
What is query cost in sql server?
What is the osql utility?
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
Is a primary key unique?
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)