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
- 9692 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 |
What is the difference between severity and priority? Tell me example.
10. How long have you been involved in Web accessibility?
What is Data base testing in manual
Explain all kinds of testing?
how can u map SDLC With STLC
Explain the End Goals of Usability Testing?
Hi Everybody could you please send me the ISTQB Material to my mail id karthik18487@gmail.com Thanking you in advance
Test cases for google home page, yahoo signin page, elavator, traffic signals. And can anybody post the some other testcase(on like pen,keyboard....) as interview point of view.
FOR what type of prjects we r using automation,why?
could u please suggest good coaching center in hyderabad to learn testing for a fresher
Is testing just sampling???
Hi, I got an offer with maveric systems and I have around 3.5 years of work experience. But inspite of that they are asking to sign a bond for 2 years and to pledge all the original certificates for that bond. Can anybody please advice me whether its a good company or not?
Automation Testing 
