Answer Posted / Parul Sonker
In SQL, a JOIN is used to combine rows from two or more tables based on a related column between them. There are several types of joins including INNER JOIN (returns only the matching rows), LEFT JOIN (returns all rows from the left table and the matching rows from the right table), RIGHT JOIN (returns all rows from the right table and the matching rows from the left table), and FULL OUTER JOIN (returns all rows from both tables, including non-matching rows).
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is inner join faster than left join?
Is primary key always clustered index?
Can delete statement be rollbacked?
Is primary key clustered index?
How do I remove duplicates in two columns?
how to use regular expression in pattern match conditions? : Sql dba
how to escape special characters in sql statements? : Sql dba
If a cursor is open, how can we find in a pl/sql block?
what is dbms? : Sql dba
Can we use distinct and group by together?
what are the advantages of sql ? : Sql dba
What is the best sql course?
Do we need to rebuild index after truncate?
What is your daily office routine?
how to start mysql server? : Sql dba
