Top "Union" questions

Use this tag only for questions about UNION, a keyword of the SQL language for combining the results of multiple SQL queries.

SELECT UNION as DISTINCT

How do I perform a DISTINCT operation on a single column after a UNION is performed? T1 -- ID Value 1 1 2 2 3 3 …

mysql union distinct
Quick way to extend a set if we know elements are unique

I am performing multiple iterations of the type: masterSet=masterSet.union(setA) As the set grows the length of time …

python set union
How do I combine complex polygons?

Given two polygons: POLYGON((1 0, 1 8, 6 4, 1 0)) POLYGON((4 1, 3 5, 4 9, 9 5, 4 1),(4 5, 5 7, 6 7, 4 4, 4 5)) How can I calculate the union (combined polygon)? Dave's example uses SQL server to produce …

math geometry union
Incorrect usage of UNION and ORDER BY?

how can i use union and order by in mysql ? select * from _member_facebook inner join _member_pts ON _member_…

mysql sql-order-by union
HiveQL UNION ALL

I have table_A: id var1 var2 1 a b 2 c d Table_B: id var1 var2 3 e f 4 g h …

hadoop union hive hiveql
SQL Performance UNION vs OR

I just read part of an optimization article and segfaulted on the following statement: When using SQL replace statements using …

mysql sql performance union
How to write UNION in Doctrine 2.0

How to write this SQL query in Doctrine 2.0 (and fetch results)? (SELECT 'group' AS type, CONCAT(u.firstname, " ", u.surname) …

sql union doctrine-orm
Why would I want .union over .unionAll in Spark for SchemaRDDs?

I'm trying to wrap my head around these two functions in the Spark SQL documentation– def union(other: RDD[Row]): …

sql scala apache-spark union union-all
Support UNION function in BigQuery SQL

BigQuery does not seem to have support for UNION yet: https://developers.google.com/bigquery/docs/query-reference (I don't mean …

sql google-bigquery union