inner join,outerjoin,trigger,stored procedure explain with
code snippets?
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 |
is public static void main() work in java?is "String arg[]" needed as argument?
write a program that will ask the user to enter a number n and display the product of all numbers from 1 to n.
write a program in java to solve a system of n-variabled simultaneous equations using the guassian elimination method. let the maximum possible value of n be 100. run the program using hypothetical values for a set of 10- variables simultaneous equations. print out the program, the input equation and the results generated by the program.
Write a program to convert a decimal number to binary form?
does anyone know the code to display a triangle using a applet?
1+(2*3)+(4*5*6)+(7*8*9*10)+... specified input value
write a java program to create a Frame with three scrolls, change the back ground color of the frame using functions with values of scrolls.
In java, why do we set thread priority, when we know that there is no guarantee by which a thread should be execute?
how to store and retrive a set of values without using an array
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.
write a program in java to find the moving average of all prime numbers between 2 and 100.
How to create and run runnable jar file of a Java Project.
4 Answers HCL, TCS, Tech Mahindra, US Consulate, Wipro,