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
Can sql servers link to other servers like oracle?
Why and when do stored procedure recompile?
What is subquery? Explain the properties of a subquery?
do you know how to configure db2 side of the application? : Sql server database administration
What is the difference between upgrade and migration in sql server?
What is a view in sql?
Equi join and non equi join is possible with sql server?
What is standby servers? Explain types of standby servers.
What are the source of constraints?
What is normalization and what are the advantages of it?
What are the different SQL Server Versions you have worked on?
How do I find the sql server version?
What kind of problems occurs if we do not implement proper locking strategy?
Can we do dml on views?
What is acid mean in sql server?
