what is the difference between union and union all
Answer Posted / anjani kumar
Union will return only distinct values from two tables.
Union all will return duplicate values from the two tables
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
What are all the ddl commands?
what is rdbms? : Sql dba
what are date and time data types in mysql? : Sql dba
What is an exception in pl/sql?
Explain the commit statement.
what are the authentication modes in sql server? : Sql dba
What is sql data?
What is procedure in pl sql?
What is dynamic sql in pl sql?
How do you remove duplicates without using distinct in sql?
What are different types of sql?
Why stored procedures are faster than query?
What is dialect in sql?
Are sql connections encrypted?
What is union?