SQL Federated Query

Source: Internet
Author: User
Federated Query
The Union operator can combine a collection of query results from two or more SELECT statements into a single result set, that is, to execute a federated query. The syntax format of the Union is:
UNION [All] selectstatement
[UNION [All] selectstatement] [... n]
Where Selectstatement is the SELECT query statement to be joined.
The all option means that all rows are merged into the result collection. When this item is not specified, the duplicate rows in the Federated query result collection are persisted to only one row.
In a federated query, the column headings of the query results are the column headings of the first query statement. Therefore, to define a column heading must be defined in the first query statement. To sort federated query results, you must also use the column name, column heading, or column ordinal in the first query statement.
When using the union operator, you should ensure that there are the same number of expressions in the select list for each federated query statement, and that each query selection expression should have the same data type, or you can automatically convert them to the same data type. In the case of automatic conversion, the system converts a low precision data type to a high precision data type for numeric types.
In a union statement that includes multiple queries, the order of execution is from left to right, and parentheses can be used to change the order of execution. For example:
Query 1 Union (query 2 union query 3)
Original Author: unknown
Source: Design Practice of MSSQL

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.