Interested to Buy Any Domain ? << Click Here >> for more details...
What is a join and explain different types of joins?
- 2 Answers
- 5742 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
You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?
How can you log an error to the server event log from a stored procedure?
Explain about a primary key?
Which data type cannot be used as a parameter in a udf?
Explain about xml databases?
How to use timestamp datatypes
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
I have a few records all are same structures data, I want to store data in multiple targets how
In which table collections errors are stored.
Write the fastest query to find out how many rows exist in a table?
How to read and create .LDC data files which are used by linguatic dictionary.
What are the main phases of database development?
Explain about normal forms?
How to customize error conditions.
Who are end users in dbms?
