What is the difference between join and union.
Answer Posted / mohan
join is used to combine two different tables where as in union
union also perform the same operation but the difference is
union will return distinct(unique) values.we can eliminate
the duplicate records while using union
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
what is a trigger in mysql? : Sql dba
What normalization means?
what is csv? : Sql dba
Write the alter statement to enable all the triggers on the t.students table.
What is sqlcontext?
Do stored procedures prevent sql injection?
What is sqlca in db2?
discuss about myisam key cache. : Sql dba
What is secondary key?
can sql servers linked to other servers like oracle? : Sql dba
What are expressions?
how to write date and time literals? : Sql dba
Is there a way to automate sql execution from the command-line, batch job or shell script?
tell me about various levels of constraint. : Sql dba
what is the difference between truncate and drop statements? : Sql dba