Answer Posted / Anshu Sharma
SQL JOIN is a set operator that combines rows from two or more tables, based on a related column between them. It can be INNER JOIN (only returns matching rows), LEFT JOIN (returns all rows from the left table and matching rows from the right table), RIGHT JOIN (returns all rows from the right table and matching rows from the left table), or OUTER JOIN (a combination of LEFT and RIGHT join).
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is sql server agent? : Sql dba
If a cursor is open, how can we find in a pl/sql block?
How do I remove duplicates in two columns?
define sql insert statement ? : Sql dba
Is primary key always clustered index?
What is the current version of sql?
what is collation? : Sql dba
Do we need to rebuild index after truncate?
Can delete statement be rollbacked?
what is schema? : Sql dba
Can we rollback truncate?
how many tables will create when we create table, what are they? : Sql dba
how to use regular expression in pattern match conditions? : Sql dba
how to escape special characters in sql statements? : Sql dba
what are aggregate and scalar functions? : Sql dba
