Most voted "union-all" questions
7 questions
Sort by count of
-
15
votes2
answers10671
viewsWhat’s the difference between Union and Union All?
What’s the difference between UNION and UNION ALL? If possible, include examples of use.
-
4
votes2
answers276
viewsUsing a select with UNION or other mysql parameter
I am developing cash flow from my company and am encountering a difficulty. I have two different tables. A table is a tb_compras(id, fornecedor, nfe, valor, data) and then I have another table…
-
1
votes3
answers55
viewsI tried a Union consultation but did not get the expected result
I made a query with two selects using union and it has two columns: MOBI and DESMOBI. I need the result to show these two columns. when I run it shows only the column MOBI`. Below follows the query.…
-
1
votes0
answers125
viewsUnion All for Entity framework using Lambda
I’m having problems in a query using lambda and Entity Framework in C#. When transforming a simple sql query into lambda works perfectly, as example below. SQL query public DataSet ListarRecebidos()…
-
0
votes2
answers84
viewsUnion All specify select no order by
I have ONE test table and I’m doing a Union All and I want to sort by date but not sort by the first select before Union All which would be a headline. I would like to order only the data of the…
-
0
votes1
answer58
views -
-2
votes1
answer120
viewsSubconsulta returns more than one value
Good night! I have an sql query based on a CTE and I want to take the largest value between a subconsulta, but when I run the main query the subconsulta error returns more than one value appears.…