adspace


What does an inner join do?

Answer Posted / Sumeet Bhatnagar

"An INNER JOIN combines rows from two or more tables, based on a related column between them. It only returns the matched rows (rows with matches in both tables)."n

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is primary key clustered index?

1025


How do I remove duplicates in two columns?

1201


Does group by remove duplicates?

1118


what is schema? : Sql dba

1160


Is inner join faster than left join?

1286


how to start mysql server? : Sql dba

1278


What is the current version of sql?

1103


how many tables will create when we create table, what are they? : Sql dba

1153


What is the best sql course?

1061


If a cursor is open, how can we find in a pl/sql block?

1251


Do we need to rebuild index after truncate?

1151


Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2099


how to escape special characters in sql statements? : Sql dba

1124


define sql insert statement ? : Sql dba

1107


how to use regular expression in pattern match conditions? : Sql dba

1122