self join query in sql.
15 objective questions.
What is equi join and outer join
Answer Posted / swaroopa
What is Equi Join and Outer Join ?
Equi Joins are also called Simple Joins or Inner Joins.
An equi-join is a join based on equality or matching
between the column values for two different tables.
This equality is indicated with an equal sign (=) as the
comparison operator in the WHERE clause
Ex:SELECT * FROM manufact, stock
WHERE manufact.manu_code = stock.manu_code
manufact and stock are the tables on the manu_code column.
It retrieves only those rows for which the values of the
two columns are equal.
Outer Join:
OUTER JOIN is used to join two tables even if there is not
a match. The joined table retains each record—even if no
other matching record exists. Outer joins subdivide further
into left outer joins, right outer joins, and full outer
joins, depending on which table(s) one retains the rows
from (left, right, or both).
Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
write test case for gmail sign up page ?
What is virtual creation tool?
How can I use bugzilla in my company to track a bug and to allow the client to see the bug report online throughbugzilla. Please explain in detail. I am really need this.
what is functional testing terminologies
Can you do system testing at any stage of sdlc?
define risk management system with example ?
Hi, My name is Dinesh.I want to prepare for ISTQB certification , So can anyone please email me the syllabus of it and what is criteria for giving exam.Please email me answers at: dinesh0323@live.com
Being an Manual tester, what will be the role or activity in test plan ?
Why do we need different environments and different data? What is the other name for environment? Justify your explanation ? real time experts pls xplain?
What are the main key components in web applications and client and server applications?
After insert the record in front-end, how will you check the back end by manually? Please explain?
Write the function test case to add a customer to database.
I have 6 months experience as project tarine and one and a half year experience as software engineer.Should i write taht my total experience id 2 years.
aplitue questions will be based on wich type ?
write the test case for Bulb & Mobile phone