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 are the basic techniques of indexing?
How do I install sql?
What is sqlcommand?
Does group by remove duplicates?
What are different types of functions in sql?
What is database sql?
How can we make an if statement within a select statement?
Which language is used in sql?
what is union, minus and interact commands? : Sql dba
What is sql partition?
how many sql ddl commands are supported by 'mysql'? : Sql dba
What is clustered and nonclustered index in sql?
What are the operators in sql?
Explain about various levels of constraint.
Why do we use joins?