Interested to Buy Any Domain ? << Click Here >> for more details...
self join query in sql.
15 objective questions.
What is equi join and outer join
- 2 Answers
- 9723 Views
- Bally Technologies, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / latha
self join:one physical table is divided into two logical tables and perform join operation on that tables.
query:
select a.eno,a.ename,b.ename as manager name from emp a,emp b where a.manager num=b.eno
equi join:perform join operations on matching columns on both the tables
| Is This Answer Correct ? | 1 Yes | 1 No |
Describe Software Testing life cycle? What are the steps in volved in STLC (Software Testing Life Cycle)?
plz anyone can explain me what is PB/MF based application?
In my application, date box is present on every screen. As a tester I have to test it on every screen. So need to write test case for it. If I write a test case for Date box only once & I refer that test case for next screen date box testing. Is it Ok?? E.g. Test case name - Date Box test Test Case Id - 01 If I want to write test case for Date box on New screen/module. Then is it OK?? Test Case Name - Date Box test Test Case Id - 20 Test Steps - Refer steps of test case id-01
what is corrective & Preventive Action
What is your Future Plans for the Company if Permanently Employed?
Hello people...im planning to jump into Manual Testing field. How should i start. Please guide me.. Thank you
What is the difference between Technical TestCase and functional Testcase.
what is the format of test case document? any one can send test case excel sheet format? my id :chinna.4494@yahoo.com
What is the role of tester in SDLC cycle ( in each phase )
I am a manual test engineer working on an web application product testing.I have worked on test mgmt tool-testlink,defect tracking tool=bugzilla and I know functional-selenium ide (basics.So can anyone tel me which scripting language is extensively used in testing tools so that i can acquire some knowledge about it in order to shift into automation?
Define load, performance and stress testing
What is difference between regression testing and re- testing?
Automation Testing 
