Interested to Buy Any Domain ? << Click Here >> for more details...
What is an inner join, and an outer join ?
- 1 Answers
- 13040 Views
- CTA, I also Faced
- E-Mail Answers
Answer / s
Inner Join return only matching rows whereas Outer Join
returns matching rows from both tables and unmatched rows
from either of the table depending on the join.
RIGHT outer Join returns matching rows and unmatched rows
from the right table.
LEFT outer join returns matching rows and unmatched rows
from the left table.
| Is This Answer Correct ? | 27 Yes | 2 No |
cobol-db2 runjcl please?
What is buffer pool?
what is commit & rollback? When and where is used while compiling a cobol-db2 program?
Which component is responsible for db2 startup and shutdown?
What is the difference between bind and rebind in db2?
How can we retrieve the total number of records in RPG & CLLE?
If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?
how to copy the host variables from ps file into cobol program other than include statement
How many databases can be created inside an instance in db2 ?
Explain the function done by data manager?
How do I delete a column in db2?
what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx
COBOL 
