self join query in sql.
15 objective questions.
What is equi join and outer join
- 2 Answers
- 8634 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 |
Suppose you have given less time and you have quite few test cases to run what will your steps to resolve this issue.
When do u stop testing?
Which Server Stats are essentially monitored during a Perf test of a Web Application?
After receiving the build.How will you start the testing
I am a ISTQB cerfity tester with 3 yrs experience(kolkata) , I left my current commpany due to some problem but since two months I did not get new job , why? is my age is 33 yrs and I am married . If anybody have any answer please let me know, my email id sangitadas1981@gmail.com/yahoo.co.in
1. What types of documents would you need for QA, QC, and Software Testing?
What is difference between Build, Version and Release
Who is the father of Software Testing? Who has invent the water fall model? Who has invent the spiral model? Who has invent the prototype model? Who has invent the v-v model? Who has invent the Hybrid model?
If i say that my company XYZ is a "out sourced" company then what does it mean? Plz Clear me with a practical scenario. It's Urgent
On which order testing is done regression,retesting,functional,User Acceptance Testing,Usability Testing,Smoke Testing ???
Which appraisal method class is the best?
1. AMDOCS Testing2. DW testing3. ERP testing4. Mainframe testing5. SOX Testing6. Six sigma testing7. RUP-CMM testing
Automation Testing 
