Interested to Buy Any Domain ? << Click Here >> for more details...
What is a join and explain different types of joins?
- 2 Answers
- 5765 Views
- I also Faced
- E-Mail Answers
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 the process of the user request and data generating?
How long can an error message be in raiseerror function?
What is a database development?
What are the three basic rules which are to be followed for the relational model of the database?
Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in
Write short notes on manual refreshes.
How can you log an error to the server event log from a stored procedure?
What is DB Development software?
Explain about normal forms?
How to use timestamp datatypes
How is data stored in dbms?
What are the three types of database design?
Which data type cannot be used as a parameter in a udf?
State the acid rules?
How to generate OIDS
