Interested to Buy Any Domain ? << Click Here >> for more details...
What are joins..how many types of joins are there?
- 29 Answers
- 96978 Views
- Amdocs, CSC, TCS, I also Faced
- E-Mail Answers
Answer Posted / sourabh sharma
=>INNER JOIN: Return rows when there is at least one match
in both tables
=>LEFT JOIN: Return all rows from the left table, even if
there are no matches in the right table
=>RIGHT JOIN: Return all rows from the right table, even if
there are no matches in the left table
=>FULL JOIN: Return rows when there is a match in one of the
tables
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
What are data pump export and import modes?
How to write a query with a left outer join in oracle?
Is insert autocommit in oracle?
Differentiate between function and procedure in oracle.
Explain cascading triggers.
How to calculate date and time differences in oracle?
What is a system tablespace and when it is created?
Define oracle database
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
how to handle exceptions in post production
How to convert characters to numbers in oracle?
What types of joins are used in writing subqueries?
How to open a cursor variable?
What is the difference between PFILE and SPFILE in Oracle?
