self join query in sql.
15 objective questions.
What is equi join and outer join
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 |
how many members are involved in test plan? and tell me names?
In Manual testing BDD meaning
What is Changing requirement?
What is Test management?
Hi i am new to testing.. Can u plz tell wat is mean by manual testing and how it is done?
give an example for load testing
Negative testcases for dropdownlist???
how many meeting in realtime environment? what are they?plz explain?
write 3 test cases on MSWORD
What is software review?
Hi If anyone from banglore want to know the real time senario like writting Test cases and how things actually happens in a company. I am taking a 2 hours class which will cover all the real time experiance and guidence for job. classes are counducted only at weekends. for further queries mail me at vinodhanandhan@gmail.com Vinodh Anandhan Software Test Engineer vinodhanandhan@gmail.com
What is build and patch?