The SQL intersect operator returns rows that are common between two tables without returning duplicate records.
Questions tagged [intersect]
643 questions
3
votes
2 answers
JavaFX intersection of shapes and polygons
I'm currently working on intersect of bounds between different shapes with JavaFX.
I would like to detect collision of two polygons on their points and not on their bounds (i.e. 2 polygons).
Please, see figure 1: not desired behavior, and figure 2:…
PacDroid
- 541
- 1
- 7
- 22
3
votes
2 answers
Multiple-item IN operator AKA set intersection in MySQL
mysql> SELECT * FROM nodes
-> WHERE hostName IN ('localhost', 'm1iafw') OR
-> address IN ('localhost', 'm1iafw');
+----------------------+-----------+-----------+
| id | hostName | address …
John Kugelman
- 349,597
- 67
- 533
- 578
3
votes
2 answers
Find common values (Intersection) from one column of a table depending on the given values of second column of same table
I've following table which specifies the areas where suppliers deliver their products, with three columns as
ID Supp_ID Area_ID
1 a P
2 a R
3 a T
4 a s
. . .
. . .
5 …
Saurabh Palatkar
- 3,242
- 9
- 48
- 107
3
votes
1 answer
Ravendb Array intersect
I have a simple Raven dB table which is as follows:
char[] colorArray= colorValue.ToCharArray().Distinct().ToArray();
for loop{
var entity = new Color { ID = id, colorArray = colorArray };
session.Store(entity);
}
Session.Savechanges();
This table…
bvk
- 122
- 2
- 8
3
votes
1 answer
VB.NET collision between pictureboxes
I'm trying to make a simple game and i need to know if picturebox1( my character) collides with other pictureboxes ( the walls).
I have already worked out how do this but it only works with my character and 1 other picturebox for example:
If…
user2151534
- 33
- 1
- 1
- 3
3
votes
1 answer
Intersection of the two data sets
I have two time series of share prices, Price1 and Price2. Tday is the time series of the dates which match for both prices. Now I am trying to match the prices of each to the newly established tday (matching dates time series). I am following…
Noob_1
- 145
- 3
- 12
3
votes
3 answers
Ray intersection with 3D quads in XNA?
So I have successfully made a ray the represents the mouse unprojected into the world, and now I need to check if that ray can intersect with a quad object, here is the code I use to get the ray:
public Ray GetMouseRay()
{
Vector2…
Glen654
- 1,102
- 3
- 14
- 18
3
votes
5 answers
How to intersect mutliple list with Lambda Expression?
I have a few list. Their count isn't clear.
For example (for 4 list):
List1 List2 List3 List4
----- ----- ----- -----
1 2 3 4
2 4 8 3
3 8 4 5
4 …
Sinan AKYAZICI
- 3,942
- 5
- 35
- 60
3
votes
1 answer
C# Intersecting Partial Matches
Good Afternoon all,
I'm trying to run a comparison of the contents of 2 folders and I have it working after-a-fashion but I'm curious whether there's a better way. Here's what I have:
static void Main(string[] args)
{
…
Sam2S
- 165
- 1
- 6
2
votes
4 answers
Linq intersect with sum
I have two collections that I want to intersect, and perform a sum operation on matching elements.
For example the collections are (in pseudo code):
col1 = { {"A", 5}, {"B", 3}, {"C", 2} }
col2 = { {"B", 1}, {"C", 8}, {"D", 6} }
and the desired…
Mart
- 5,608
- 3
- 32
- 45
2
votes
5 answers
python intersect of dict items
Suppose I have a dict like:
aDict[1] = '3,4,5,6,7,8'
aDict[5] = '5,6,7,8,9,10,11,12'
aDict[n] = '5,6,77,88'
The keys are arbitrary, and there could be any number of them. I want to consider every value in the dictionary.
I want to treat each string…
khany
- 1,167
- 15
- 33
2
votes
4 answers
Microsoft Excel VBA Intersect with Rename Sheet
I'm trying to change the name of a sheet after it is created under and Intersect method. The code I have below give Error 424. The code works when only creating a new sheet.
Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As…
Frank
- 61
- 1
- 7
2
votes
2 answers
How can I intersect more than two sets/lists of values?
Here is an example that works in Linqpad. The problem is that I need it to work for more than two words, e.g. searchString = "headboard bed railing". This is a query against an index and instead of "Match Any Word" which I've done, I need it to…
Larry Pittman
- 147
- 10
2
votes
1 answer
Why is, in SQLite, `SELECT (SELECT 1 UNION SELECT 2 UNION SELECT 3) INTERSECT SELECT 3 UNION SELECT 4` equal 4 and not 3?
In SQLite, if I type:
SELECT (SELECT 1 UNION SELECT 2 UNION SELECT 3) INTERSECT SELECT 3 UNION SELECT 4
I get the result 4. How is that possible?
SELECT 1 UNION SELECT 2 SELECT 3 is (1, 2, 3), right? And SELECT 3 UNION SELECT 4 is (3, 4). So, the…
FlatAssembler
- 667
- 7
- 30
2
votes
1 answer
Intersecting polygons from two sf objects sharing a common attribute (unique and one-to-one)
I have two sf objects that each contains 3 polygons (circles). Each polygon in each object has a unique, one-to-one identifier ('name'). I want to intersect these two objects so that it returns an object of the same length where each geometry is the…
SteveH
- 21
- 2