What is a join and explain different types of joins?
Answers were Sorted based on User's Feedback
Answer / dhivya
Joins are used to fetch the records from more than one
table ,there are 4 types of joins
1.Equi-Join
2.Non-Equi-join
3.outer-join
4.Self-join
Is This Answer Correct ? | 3 Yes | 2 No |
Answer / 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 |
What is a join and explain different types of joins?
what is the use of foreginkey
I have a few records all are same structures data, I want to store data in multiple targets how
0 Answers CTR, Infosys, Polaris,
You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
Why does this query return 0?
What are defaults? Is there a column to which a default can't be bound?
Explain the cube operator?
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?
hi in which phase of mload can i use .FILLER
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.
1. Using the XML Document below, with the URI “recipe.xml” define the following queries in XQuery: a.) Give the names of all breakfast in the menu. b.) Select breakfasts that have price lower than $7.00? <?xml version="1.0"?> <breakfast_menu> <food> <name>Belgian Waffles</name> <price>$5.95</price> <description> two of our famous Belgian Waffles with plenty of real maple syrup </description> <calories>650</calories> </food> <food> <name>Strawberry Belgian Waffles</name> <price>$7.95</price> <description> light Belgian waffles covered with strawberries and whipped cream </description> <calories>900</calories> </food> <food> <name>Berry-Berry Belgian Waffles</name> <price>$8.95</price> <description> light Belgian waffles covered with an assortment of fresh berries and whipped cream </description> <calories>900</calories> </food> <food> <name>French Toast</name> <price>$4.50</price> <description> thick slices made from our homemade sourdough bread </description> <calories>600</calories> </food> <food> <name>Homestyle Breakfast</name> <price>$6.95</price> <description> two eggs, bacon or sausage, toast, and our ever-popular hash browns </description> <calories>950</calories> </food> </breakfast_menu>
Explain the process of the user request and data generating?