Answer Posted / saravakumar
UNION RULES
A UNION must be composed of two or more SELECT statements,
each separated by the keyword UNION.
Each query in a UNION must contain the same columns,
expressions, or aggregate functions, and they must be listed
in the same order.
Column datatypes must be compatible: They need not be the
same exact same type, but they must be of a type that SQL
Server can implicitly convert.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is the concept of optimization?
Write a program using SQL queries to find a unique entry in a table.
Explain view in sql server?
What is ms sql server index?
What are acid properties of transaction?
Explain what is the use of custom fields in report?
Explain optimistic and pessimistic concurrency?
What is de-normalization and what are some of the examples of it?
What is the new security features added in sql server 2016? : sql server security
what is checksum in sql server.........???
Can you get second highest salary from the table?
How can you manage sql azure security?
How to create an index on an existing table in ms sql server?
How to manipulate data from one table to another table ?
What is unique key constraint?