what is the difference between union and union all
Answer Posted / ranjay kumar singh
union is used to select distinct values from two tables
where as union all is used to select all values including
duplicates from the tables
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
List the different type of joins?
What are triggers in sql?
Can ddl statements be used in pl/sql?
What is schema in sql?
What is audit logout in sql profiler?
What is memory optimized table?
What is difference between table and view?
Which language is used in sql?
What are predefined functions in sql?
What is ttitle and btitle?
Can a view be mutating? If yes, then how?
what is difference between delete and truncate commands? : Sql dba
What is a primary key called that is made up of more than one field?
What is cross join sql?
explain commit and rollback in mysql : sql dba