inner join,outerjoin,trigger,stored procedure explain with
code snippets?



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

Post New Answer

More J2SE Code Interview Questions

is public static void main() work in java?is "String arg[]" needed as argument?

4 Answers   Tech Mahindra,


write a program that will ask the user to enter a number n and display the product of all numbers from 1 to n.

1 Answers  


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.

0 Answers   TCS,


Write a program to convert a decimal number to binary form?

1 Answers   Oracle,


does anyone know the code to display a triangle using a applet?

1 Answers  






1+(2*3)+(4*5*6)+(7*8*9*10)+... specified input value

1 Answers   MAQ,


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.

0 Answers  


In java, why do we set thread priority, when we know that there is no guarantee by which a thread should be execute?

0 Answers   Google, Microsoft,


how to store and retrive a set of values without using an array

8 Answers   FCS, HCL, Maximus,


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.

1 Answers   RoboSoft,


write a program in java to find the moving average of all prime numbers between 2 and 100.

0 Answers  


How to create and run runnable jar file of a Java Project.

4 Answers   HCL, TCS, Tech Mahindra, US Consulate, Wipro,


Categories