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.

Getting a distinct value across 2 union sql server tables

I'm trying to get all distinct values across 2 tables using a union. The idea is to get a count of …

Read More
sql union distinct distinct-values
Getting the union of two maps in go

I have a recursive function that creates objects representing file paths (the keys are paths and the values are info …

Read More
map go union
How can I treat a UNION query as a sub query

I have a set of tables that are logically one table split into pieces for performance reasons. I need to …

Read More
sql db2 subquery union
The used SELECT statements have a different number of columns

For examples I don't know how many rows in each table are and I try to do like this: SELECT * …

Read More
sql mysql union
How to do a count on a union query

I have the following query: select distinct profile_id from userprofile_... union select distinct profile_id from productions_... How would …

Read More
mysql sql union aggregate-functions
select max, min values from two tables

I have two tables. Differ in that an archive is a table and the other holds the current record. These …

Read More
sql database select union
Select from union tsql

Is it possible to select from the result of a union? For example I'm trying to do something like: SELECT …

Read More
sql sql-server-2005 union
How to use union all in LINQ?

How to use union all in LINQ TO SQL. I have use the following code for union, then how to …

Read More
linq linq-to-sql union
how to convert sql union to linq

I have the following Transact SQL query using a union. I need some pointers as to how this would look …

Read More
c# sql linq union
Combine multiple SELECT statements

I've used Excel to generate numerous SELECT statements from a list of the schema names from a database with a …

Read More
sql postgresql union