What is the difference between join and union.
Answer Posted / vijay kulkarni
In Join, matching rows are joined side-by-side to make the
result table but whereas in Union rows are joined one-below
the other to make the result table.
| Is This Answer Correct ? | 21 Yes | 33 No |
Post New Answer View All Answers
what is sql? : Sql dba
Which kind of parameters cannot have a default value in pl sql?
What is implicit cursor in pl sql?
What is sqlcommand?
what is the difference between delete and truncate commands? : Sql dba
What is %s in sql?
how do you control the max size of a heap table? : Sql dba
Which data dictionary views have the information on the triggers that are available in the database?
Where do we use pl sql?
How do I kill a query in postgresql?
How can we debug in PL/SQL?
Can we rollback truncate?
Mention what is the function that is used to transfer a pl/sql table log to a database table?
What are all the ddl commands?
How can we avoid duplicating records in a query?