Interested to Buy Any Domain ? << Click Here >> for more details...
What is a join and explain different types of joins?
- 2 Answers
- 5874 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
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
What are the constraints on severity level in raiseerror?
How would you design a database for an online site, which would average a million hits a day?
What is dbms and its application?
What are the three types of database design?
State the acid rules?
explain detail about ftp in datastage?
How to read and create .LDC data files which are used by linguatic dictionary.
The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?
Explain about relational database management systems?
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS
What is an application role and explain a scenario when you would use one?
In which table collections errors are stored.
In which database can extended stored procedures be added?
Who are end users in dbms?
