Top "Union-all" questions

What is the difference between UNION and UNION ALL?

What is the difference between UNION and UNION ALL?

sql union union-all

How to execute UNION without sorting? (SQL)

UNION joins two results and remove duplicates, while UNION ALL does not remove duplicates. UNION also sort the final output. …

sql union distinct union-all

Combining ORDER BY AND UNION in SQL Server

How can I get first record of a table and last record of a table in one result-set? This Query …

sql sql-server sql-order-by union-all

How can I do a Union all in Entity Framework LINQ To Entities?

I came across a scenario where I had to use Union all, how can I achieve so in LINQ to …

c# linq tsql entity-framework-4 union-all

Scala Spark : How to create a RDD from a list of string and convert to DataFrame

I want to create a DataFrame from a list of string that could match existing schema. Here is my code. …

scala apache-spark dataframe rdd union-all

Group By and Order By with UNION ALL

I have a stored procedure with the following query: SELECT (sum(addition)) AS [COUNT], MAX(CONVERT(VARCHAR(12),CREATED,102)) as [date] …

sql sql-server-2008 group-by sql-order-by union-all

UNION ALL two SELECTs with different column types - expected behaviour?

What is the expected behaviour due to SQL Standard when we perform UNION on two tables with different data types: …

sql sql-server tsql standards union-all

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

Slow query on "UNION ALL" view

I have a DB view which basically consists of two SELECT queries with UNION ALL, like this: CREATE VIEW v …

sql performance postgresql indexing union-all

performance of union versus union all

I have to run a select statement across several tables. I am sure the tables return different records. I am …

sql-server performance union union-all