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 |
You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?
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
What are the three basic rules which are to be followed for the relational model of the database?
What is an application role and explain a scenario when you would use one?
Write short notes on manual refreshes.
How to read and create .LDC data files which are used by linguatic dictionary.
What is data modeling with example?
Explain about normal forms?
What are the key features of dbms?
Explain what a database is?
Why does this query return 0?
How can you log an error to the server event log from a stored procedure?