Answer Posted / samy
Union:
combine two tables and common values to be retrieved no
duplicate values
Union All:
All the values to be retrieved when combine two table.
(duplicate values)
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
Tell me something about security and sql azure?
What command is used to rename the database?
What are difference between Cluster index and Non-Cluster index?
Which rendering formats are affected by the pagesize properties?
What is sql server replication? : sql server replication
What is constraints and its types?
What is subquery in sql?
What is 2nf normalization?
How to filter out duplications in the returning rows in ms sql server?
What is difference between commit and rollback when used in transactions?
How to delete duplicate rows from table except one?
How do you create an execution plan?
Explain tablesample?
What is the difference between having clause and where clause in sql server?
How to change parameter value inside the report?
