What is the difference between join and union.
Answer Posted / nafisul haque
Join returns matching/non matching records as per condition
where as union returns union of recordsets. Join is used
within single select statement while union is used among
two or more select statements.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is output spooling in sql*plus?
write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba
Why we use sql profiler?
What does truncate mean in sql?
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
What pl/sql package consists of?
what are myisam tables? : Sql dba
What has stored procedures in sql and how we can use it?
How much does sql certification cost?
How can we implement rollback or commit statement in a trigger?
Do foreign keys improve performance?
What are the key differences between SQL and PL SQL?
What is the difference between Union and Union all. Which is faster.
What does <> sql mean?
what does the t-sql command ident_incr does? : Transact sql