What is a join and explain different types of joins?
Answer Posted / kavita
Join are used to link then retrive data from same or
different database(both have atleast one common attribute).
Join are basically of two types:
1)Equi Join
2) Non equi join
Equi join are those in which we use "=" operator in
condition.They are further divided into
a)inner join:-In this only those rows are return which
satisfy the condition.
b)Outer join:In this all rows are return in which either one
table satisfy the condition
Outer Join are again classified into left join and right join.
2)Non Equi Join are those in which we use ">","<",">=","<="
operator for retriving tuples from two tables
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
explain detail about ftp in datastage?
How you can make a parameterized view?
In which table collections errors are stored.
How to customize error conditions.
Who are end users in dbms?
State the acid rules?
Explain the cube operator?
Why does this query return 0?
Explain the process of the user request and data generating?
How can I detect whether a given connection is blocked?
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS
Explain about relational operator join?
Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.
Which data type cannot be used as a parameter in a udf?
Explain the role of indexing in databases?