self join query in sql.
15 objective questions.
What is equi join and outer join
- 2 Answers
- 9921 Views
- Bally Technologies, I also Faced
- E-Mail Answers
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
Hi,friends i am going to write ICST certificate exam on augest.So can anybody post some of sample qusetions for ICST certificate exam.Really it will be useful for me
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
Which is the best testing model?
What is neutral test case?
could u pls anyone tel me .."which is the best instute that provides eficient practical knowledge and also real-time oriented knowldge to do a project in manual and automation testing..in hyd" pls send me to dis mail-id if u find any..? sinducute17@gmail.com
What are the qualities needed by a software tester?
i want to for technical interview question paper along with in tesrviwe Phases i need
Hi there Does anybody can respond to my Questions? Is some one there to answer my Questions posted in Software testing category.pls E-mail to sunitht27@yahoo.com
What is the big deal about ‘requirements’?
KINDLY FORWARD ME THE INTERVIEW QUESTIONS & ANSWERS FROM REAL TIME POINT OF VIEW FOR 1.5 YEARS EXPERIENCED CANDIDATE. MY EMAIL ID IS sky_bird433@yahoo.com
tell me 3 defects in FRS document, while doing FRS review which u have found in the last 3 years ? could u plz answer brahma412@yahoo.co.in
Can you please provide me the standard testcase review templete and Test plan templete.In my company we are not following any Standards templete so.Please guve me some Excell attachments.
You must test a trouble report where the problem cannot be reproduced. You tried using various test data files and mutations from the data files the customer sent along with the trouble report. The software does not fail the way it did at the customer's site.
Hi friends Does anyone have screen shot of POWERMHS and please can anyone post anything which will be helpful to understand POWERMHS. thanks.
About Hierarchy level in your company.
