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 |
Explain what you mean by 3 tier architecture.
If we delete pack Spec what will be the status of pack Body ?
How to list all tables having unique constraints in any of the columns in a database.
How to count the number of duplicate items in a table?
What are the 2 types of classifications of constraints in the sql server?
How to select all columns of all rows from a table with a select statement in ms sql server?
sql server syntax to add "!" sign to "name" field of "employee" table in a manner that all names have the same lenght of 20 characters
What is the stored procedure?
What are the differences between clustered and non-clustered index?
What is apply operator in sql?
Can sql servers link to other servers like oracle?
How to find tables without indexes?
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)