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 is loop in pl sql?
What is package in pl sql with an examples?
what are the differences between binary and varbinary? : Sql dba
What are different joins used in sql?
What are sql procedures?
What is sql and how does it work?
what is the command line end user interface - mysql? : Sql dba
What is program debugging?
how to create a new table by selecting rows from another table in mysql? : Sql dba
What does desc stand for?
How can a pl sql block be executed?
what are the authentication modes in sql server? : Sql dba
Why is sql important?
Can you have more than one trigger on a table?
What is a field in a database?