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 are the differences between user defined functions and stored procedures?
Is it possible to call a stored procedure within a stored procedure?
What are the properties of sub-query?
What is the appropriate number of test cases that you can write on a database?
Is it possible to have more then one foreign key in a single table? if possible, is this the good way to design the table?
How to create hyperlink from returned sql query ?
can any body tell me how to know the password of current user in sql server
Why should you use or avoid select * statements?
How use inner join in sql server?
How will you optimize a stored procedure optimization?
What is user-defined functions? What are the types of user-defined functions that can be created?
What is create statement?
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)