What is the difference between join and union.
Answer Posted / rajan nadal
In join method join the two table by Atleast one row
match enough to join that tables
but in union
union can be combine the two select satement in the table
here the two select stament table having same number of
column and and datatype then only combine the two select
statement.here union display distinct values but union all
display all the values
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is native sql query?
What is the use of & in pl sql?
What is error ora-01000: maximum open cursors exceeded
Which is faster view or stored procedure?
explain advantages of innodb over myisam. : Sql dba
How do you write an index?
What are different types of queries in sql?
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
Is time a data type in sql?
Does sqlite need a server?
What trigger means?
what is the difference between sql and t-sql? : Transact sql
What is faster join or subquery?
What is pl/sql language case sensitive?
What is lexical units in pl sql?