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 does count (*) mean in sql?
How do I use google cloud in sql?
What are the three pl sql block types?
What is clustered index sql?
What port does sql server use?
what is the difference between cluster and non cluster index? : Sql dba
What is string data type in sql?
What is query execution plan in sql?
Why do we use cursors?
What do you understand by exception handling in pl/sql?
What is the starting oracle error number? What is meant by forward declaration in functions?
Name the different types of indexes in sql and define them.
Can I learn sql in a week?
What are different types of indexes?
How to add new employee details in an employee_details table with the following details