Answer Posted / dinesh sharma
Union:Only Select Distinct Value
Union All:Select All Values Using Duplicate
All Selected Columns Must Have Same DataType
Example:
Table 1 : First,Second,Third,Fourth,Fifth
Table 2 : First,Second,Fifth,Sixth
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is log ldf?
How to transfer data from a cursor to variables with a "fetch" statement?
How except clause is differs from not in clause?
How to trouble shoot if unable to connect SQL Server
What is user-defined multi-statement table-valued function?
Where is trigger in sql server?
What is log in sql server?
What is DCL?
Determine when an index is appropriate?
List some case manipulation functions in sql?
How can I track the changes or identify the latest insert-update-delete from a table?
how can you attach more than 20 ldf files in sql server
Explain steps of normalization?
What are 3 ways to get a count of the number of records in a table?
What is set nocount on?
