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 |
we compile any program bu c:/>javac prog.java and run as c:/>java prog Here what's the meaning of c in javac. We have java Interpreter but not compiler.Then why we have to use javac. Please answer this question?
what is runtime class?
How Can I Trace A Java Program . Please Give Me Step by Step Process
1+(2*3)+(4*5*6)+(7*8*9*10)+... specified input value
write a program in java to find the moving average of all prime numbers between 2 and 100.
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.
Is there any static classes are in java give some examples
how to print a message to console without using main() function?(do not use even static blocks also.)
how to create a (*)pyramid using java codes???
what are the other loops except for for,while,do while and until?
Program to print map of India in java.
Write a program to convert a decimal number to binary form?