What is meant by Join? What are the different types of
Joins available? Explain.
Answer Posted / kilari hemadri
Joins is used to relate two tables and display the result..
types of joins are
inner join
left join
right join
full join
cross join
inner join : It is used to display the common values in
both the tables based on the condition given.
left join : Left join displays all the contents of left
table and dislays the right table contents that are present
in left table.
right join : it is contraversy to left join
full join : it is combination of both left and right joins.
cross join: it takes one row of left table and matches with
all the rows in the right table.
| Is This Answer Correct ? | 16 Yes | 4 No |
Post New Answer View All Answers
What is difference between sql and excel?
Why do we use partitions in sql?
What are the popular database management systems in the it industry?
What is application trigger?
What are all the ddl commands?
What does a pl/sql package consist of?
Why do we create stored procedures & functions in pl/sql and how are they different?
How do I truncate a word?
What are stored procedures in mysql?
Which is faster joins or subqueries?
How to fetch alternate records from a table?
Which nosql database is best?
How do I run a sql script?
what is 'mysqladmin' in mysql? : Sql dba
What is the default isolation level in sql server? : Transact sql