What Are Three Rules to Use UNION IN SQL SERVER
Answer / 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 |
what is datawarehouse?
Explain having clause and where clause?
What is logshipping and its purpose?
difference between function and procedure
3 Answers Cognizant, HCL, TCS, Theorem,
What is difference between aggregate and analytic function?
Explain the dirty pages?
What are the magic tables in SQL Server 2000?
7 Answers Infogain, Merrill Lynch,
syntax for deleting the database in T SQL
Can you explain the role of each service?
What are the characteristics of modern DBMS?
What is the use of DBCC commands?
What is a primary key?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)