The SQL intersect operator returns rows that are common between two tables without returning duplicate records.
Questions tagged [intersect]
643 questions
1
vote
1 answer
Bounds.Intersect for WPF
I have a Winforms app that allows the user to drag and drop some labels around the screen.
The objective being to put the matching labels on top of each other.
I keep a reference to these labels in a list, and at the moment i'm checking to see if…
Lucas
- 643
- 1
- 9
- 21
1
vote
4 answers
List.Intersect results changing after a foreach
I have a problem with this piece of code, when I do my intersect method everything works fine.
When I do the count on my intersection before the foreach I have 1.
After the foreach, if do the count again after the foreach I have 0, why is this…
JuChom
- 5,717
- 5
- 45
- 78
1
vote
1 answer
LINQ Group By and Intersection between groups C#
I have the following list into C#:
table_schema | table_name | field_name | field_type
public tableA fieldA character varying
public tableA fieldB timestamp
public tableA fieldC …
Stavros Koureas
- 1,126
- 12
- 34
1
vote
2 answers
C# Intersect Two Dictionaries and Store The Key and The Two Values in a List
I want to intersect the 2 dictionaries, but I am not sure how to store historicalHashTags[x] too, I managed to store only the key and value of 1 dictionary.
var intersectedHashTags =…
bob mason
- 677
- 1
- 6
- 11
1
vote
1 answer
Auto cell update with use of intersect
So basically I have a column in my spreadsheet that tracks the status of bearing conditions. 800+ bearings spread across 8 or so sheets (different areas of a facility) and will continue to increase in the future.
There is a corresponding column that…
Drew Killingley
- 13
- 5
1
vote
1 answer
Find the intersection of all combination of list of list
My ultimate goal is to have alluvial plots in R. However, my data is big and is not stored in a way that can be used for direct input, I have:
4 groups (they will be axes of the alluvial plot)
In each of these groups consist of a list of a list of…
William Wong
- 453
- 2
- 9
1
vote
1 answer
.NET replacing values where keys match
This is a simple question. I have two lists ListA and ListB they are both full of the same type of objects with keys, but everything else (besides key) can be different, the size the values etc..... I want to replace the values in ListA with values…
DemiGod
- 25
- 5
1
vote
1 answer
Excel VBA: Change cell value based on other cell value changed
I am writing the VBA that about change the cell (E19:E24) value if cell D18 value changed and change the cell D18 value if E19: E24 all or anyone cell value changed.
I want to fulfil below scenario:
When the value of D18 is "NA", the value of E19…
Alan Tse
- 47
- 4
1
vote
1 answer
Adding value to a cell (within a specified range) populates an adjacent cell
My table has a column for Date & Time where a current timestamp is added, and another column recording the observed Number of Events for that time. I have to fill Number of Events quickly, so need the Date & Time column (of the same row) to fill…
Cameron Schwarz
- 15
- 5
1
vote
1 answer
SQL Server Geography Data Type - why do two separate Polygons Intersect?
I have two geometry variables and I want to find out if they intersect.
My first variable is called @orderBounds2.
DECLARE @orderBounds2 geography
I set it to a value
set @orderBounds2 =…
AlastairS
- 11
- 1
1
vote
0 answers
How to properly use intersection observer in Vue? Writing it in onUpdated() correct?
I have an issue using intersect observer with vue3. I want to have the intersect shown and being activated with a v-if. Unfortunately it only works if I write the intersect Observer code in the onUpdated method. If I write it in the onMounted the…
user1664377
- 393
- 1
- 3
- 13
1
vote
1 answer
Apache spark : How deep is the comparison of rows in RDD or DF
I want to understand the behavior of DF.intersect().
so the question came to mind, especially when we have complex Rows having complex fields. (deep tree)
Noureddine Ettalhi
- 53
- 1
- 7
1
vote
1 answer
Looking for an equivalent to INTERSECT ALL in sqlite
I have a database which allows duplicates where the key is a string and the values are URLs. Here's the schema:
CREATE TABLE Tags (p_tags TEXT, p_urls LONGVARCHAR);
I would like to do a command like this in an efficient manner: SELECT p_urls FROM…
Lawrence Berardelli
- 13
- 4
1
vote
1 answer
How to do several consecutive intersect?
I have a SQL query like below:
select col4, col5 from TableA where col1 = 'x'
intersect
select col4, col5 from TableA where col1 = 'y'
intersect
select col4, col5 from TableA where col1 = 'z'
How can I convert this SQL to PySpark equivalent?
I can…
Temp Expt
- 305
- 1
- 4
- 17
1
vote
1 answer
How to get a postgresql query result as JSON
I have text field in a table and I want query this field using where a condition: I want to query all records that has at least one word from as list of words and returns a JSON like this:
text
The employee was fired today
He likes chocolate…
math_guy_shy
- 161
- 6