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 |
How to make a column nullable?
How to assign new column names in a view?
What is the use of @@spid?
What is the stored procedure?
What is de-normalization and what are some of the examples of it?
Find top Nth employee from each department in terms of salary?
Why and when do stored procedure recompile?
Explain “row_number()” in sql server with an example?
How do you persist objects, permissions in tempdb
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
What is sql server management studio? : sql server management studio
How each E-R model constructs can be mapped to the relational model?
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)