Interested to Buy Any Domain ? << Click Here >> for more details...
inner join,outerjoin,trigger,stored procedure explain with
code snippets?
- 1 Answers
- 8945 Views
- IBM, I also Faced
- E-Mail Answers
Answer / vj
Join:It is the combining of two rows from different tables
based on the comparative values in selected columns.
Types of Join : Cross Join, Inner Join or equi join and
Outer Join which comprises of Left join and Right join.
Inner Join : It is used to select certain fields from both
tables and only correct rows will be joined together.
Sytax:SELECT <column_name> FROM <Table1>, <Table2> WHERE
(Table1.column = Table2.column)
Outer Join:
Left join: It returns all the data's from the table
present in left of the join and only those data's from the
right tabel which matches the condition.
Syntax:SELECT <column_name> FROM <Table1> LEFT JOIN
<Table2> ON Table1.column = Table2.column (Conditions like
WHERE and USING)
Right join: It returns all the data's from the table
present in right of the join and only those data's from the
left tabel which matches the condition.
Syntax:SELECT <column_name> FROM <Table1> LEFT JOIN
<Table2> ON Table1.column = Table2.column (Conditions like
WHERE and USING)
| Is This Answer Correct ? | 17 Yes | 2 No |
Write a program to convert a decimal number to binary form?
how to print a message to console without using main() function?(do not use even static blocks also.)
A game that has five levels of play has the score for each level stored in an array. You are to write a program that goes through that array and finds: a) the minimum score, and the level at which it occurred b) the maximum score, and the level at which it occurred c)the average score for all five levels The score data you must use for this program are as follows: Game Level Score 1 450 2 316 3 148 Stack implementations is mandatory.
how to store and retrive a set of values without using an array
write a c program which takes 20 numbers in an array as input from user and rearrange them in two different array defining even or odd
write a program that inputs two real numbers then exchanges their values.
Can we run Applet in Web browser with security policy files
write a program in java to find the moving average of all prime numbers between 2 and 100.
Design a program using one-dimensional array that determines the highest value among the eight input values from a user. Display the difference of each value from the highest to the lowest.
how to create a (*)pyramid using java codes???
write a program that will ask the user to enter a number n and display the product of all numbers from 1 to n.
In java, why do we set thread priority, when we know that there is no guarantee by which a thread should be execute?
J2SE Code 
