union Questions
7
I'm doing a union on two queries, and I want to add a where clause to the result, but the where clause is added only to the first query. how can I fix that?
$notifications = DB::table('notificati...
6
Solved
I want to create a new table in SQL Server with the following query. I am unable to understand why this query doesn't work.
Query1: Works
SELECT * FROM TABLE1
UNION
SELECT * FROM TABLE2
Query2...
Wellestablished asked 25/10, 2010 at 20:46
11
Solved
How to do UNION query with PHP CodeIgniter framework's active record query format?
Quacksalver asked 11/1, 2010 at 8:37
15
Solved
I want to learn how to combine two db tables which have no fields in common. I've checked UNION but MSDN says :
The following are basic rules for combining the result sets of two queries by using ...
Analeptic asked 29/7, 2009 at 5:0
5
Solved
I'm building an RSS feed in PHP which uses data from three separate tables. The tables all refer to pages within different areas of the site. The problem I have is trying to create the link fields ...
2
Solved
5
Solved
How can I using group by with union in T-SQL? I want to group by the first column of a result of union, I wrote the following SQL but it doesn't work. I just don't know how to reference the specifi...
Cunnilingus asked 22/10, 2009 at 3:8
3
Solved
There is an error on PostgreSQL that it gives on one of my select statements. I searched the web for an answer and came out empty handed. The answer given in another question did not suit my proble...
Bolden asked 7/8, 2014 at 21:45
11
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...
2
Solved
Please explain what is the difference between union and std::variant and why std::variant was introduced into the standard? In what situations should we use std::variant over the old-school union?
...
Flipflop asked 7/2, 2017 at 5:23
4
I have two django-models
class ModelA(models.Model):
title = models.CharField(..., db_column='title')
text_a = models.CharField(..., db_column='text_a')
other_column = models.CharField(/*...*/ ...
Shrine asked 27/11, 2018 at 8:55
7
Solved
For examples I don't know how many rows in each table are and I try to do like this:
SELECT * FROM members
UNION
SELECT * FROM inventory
What can I put to the second SELECT instead of * to remov...
Purveyor asked 1/9, 2010 at 20:53
1
With the following python type definitions:
import pydantic
from typing import List, Union
import sys
import pprint
class TypeA(pydantic.BaseModel):
name:str = "Type A"
type_a_spesific...
Stoner asked 29/9, 2023 at 17:46
3
Solved
I need to create a QueryBuilder with union, is that possible ?
$qb = $this->em->createQueryBuilder()
->select('table1.numObject AS id')
->select ('table1.name AS name')
->from("M...
5
I have the following Transact SQL query using a union.
I need some pointers as to how this would look in LINQ i.e some examples
wouldbe nice or if anyone can recommend a good tutorial on UNIONS in ...
4
Solved
Error :
Union can only be performed on tables with the compatible column types.
struct(tier:string,skyward_number:string,skyward_points:string) <> struct(skyward_number:string,tier:string,sky...
Buckskins asked 5/9, 2018 at 13:22
5
Solved
I have a query that UNION's two somewhat similar datasets, but they both have some columns that are not present in the other (i.e., the columns have NULL values in the resulting UNION.)
The proble...
Set asked 16/6, 2009 at 22:42
4
Solved
Is there a way to execute multiple queries in a single solr request and get the union of results as response
my simplified schema would look like a name field and a type field(4-5 different types)...
5
Solved
I have a SQL query, looks something like this:
select name, count (*) from Results group by name order by name
and another, identical which loads from a archive results table, but the fields are...
5
Solved
I am trying to get an intuition about Union and Intersection types in typescript, but I can't figure out this case: Playground Link
interface A {
a: number;
}
interface B{
b: boolean;
}
type...
Mussorgsky asked 22/4, 2020 at 16:59
2
Solved
I have the following select statement where I need to sum each task from table tbTasks and group them by projectId from table tbProjects in order to get a record like this:
ProjectID = 1, ProjectN...
Bramwell asked 5/2, 2012 at 4:57
3
When I run below query I am getting this error
UNION types text and bigint cannot be matched
SELECT
1 AS STEP
, '' AS ProviderName
, '' AS Procedurecode
, Claimid
, Patient_First_Name
,...
Howund asked 20/7, 2015 at 15:35
6
Solved
I have to run a SELECT statement across several tables. I am sure the tables return different records. I am anyway using UNION ALL.
Is it better to use UNION or of UNION ALL in performance terms wh...
Nomenclator asked 2/9, 2010 at 14:12
3
Solved
I have two HashSet<u16>s and I would like to implement a = a U b. If possible, I'd like to use HashSet::union rather than loops or other tweaks.
I tried the following:
use std::collections::H...
6
Solved
I have a recursive function that creates objects representing file paths (the keys are paths and the values are info about the file). It's recursive as it's only meant to handle files, so if a dire...
Chanteuse asked 24/3, 2014 at 22:17
1 Next >
© 2022 - 2024 — McMap. All rights reserved.