Results 1 to 2 of 2

What is Union ALL?

This is a discussion on What is Union ALL? within the Programming forums, part of the Web Designing & Development category; UNION ALL selects all valu s. Union all will not eliminate duplicate rows, inst ad it just pulls all rows ...

  1. #1
    Member
    Join Date
    Jul 2016
    Posts
    55

    Thumbs up What is Union ALL?

    • UNION ALL selects all valu s.



    • Union all will not eliminate duplicate rows, inst ad it just pulls all rows from all tables fitting your query specifics and combines them into a table.



    • If you know that all the recor s returned are unique, use UNION ALL instead, it gives faster results.

  2. #2
    Senior Member
    Join Date
    Apr 2015
    Location
    2/31 Keysborough Close, Fiveways Business Centre, Keysborough Victoria 3173
    Posts
    139

    Default Re: What is Union ALL?

    The SQL UNION Operator. The UNION operator is used to combine the result-set of two or more SELECT statements.