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 notes on apparel testing equipments.
Can you explain steps in function points?
can u plz give an example for regression testing with example.
Did any one completed CSTE certiication? can u send sample question papers? how to apply that? pls send it to my mail id - dsnathi@gmail.com THANKS IN ADVANCE
What is defect validity ratio?
What is a testing process / lifecycle?
What do we need to build a quality QC team ? a QC manager with all junior QCs or a QC manager with all senior QCs?
List the considerations in developing testing methodology
how to clarify functional requirements and non functional requirements in a srs?
Please let me know how to test labels in web application manually and how the testcases would be. Please provide me a sample testcase
What is meant by entry criteria and exit criteria in software testing?
write test condition for testing SMS service of a mobile phone maximun length is 100 character while sending and 80 character for receiving write test scenarios do not write test cases
Why should you care about objects and object-oriented testing?
Test cases have written according to Flow of the software working or according to Screens?
iam having 2+yr sof exp in manual testing, at present working in chennai,want to relocte to hyd .if any openings let me know.my id : vaniramymail.com