The SQL intersect operator returns rows that are common between two tables without returning duplicate records.
Questions tagged [intersect]
643 questions
0
votes
1 answer
read.table, diff and intersect error
I have written a script to read a file from disk and check the values in it and write 3 other files on disk. Unfortunately, something that seemed to be very straight forward came out being a headache. The code is:
Arqcodnegs…
Newbie1971
- 5
- 3
0
votes
1 answer
PHP convert CSV files into arrays and intersect
I have six CSV files that I want to convert into individual arrays and then intersect those arrays to see all of the values that are similar in each. I have this so far:
$directory = "/csv/CSS_AUDIT/";
if (! is_dir($directory)) {
…
user2191353
- 53
- 6
0
votes
1 answer
when to use intersect in a query
i am a bit comfused about when do i have to use intersect in sql.The example that i am given is the following:
I have two tables:
MovieStar(name, address, gender, birthdate)
MovieExec(name, address, cert#, netWorth)
The example asks to find the…
Zisis Diamantis
- 121
- 1
- 2
- 10
0
votes
1 answer
Query evaluation with "INTERSECT" function
I've a query:
QUERY1{statements...}
INTERSECT
QUERY2{statements...}
I need to evaluate these 2 queries according to giving database data, my question is:
do I have to evaluate each query separately and then combine the 2 results together? i.g:…
Hanin
- 33
- 5
0
votes
2 answers
Array intersection issue (Matlab)
I am trying to carry out the intersection of two arrays in Matlab but I cannot find the way.
The arrays that I want to intersect are:
and
I have tried:[dur, itimes, inewtimes ] = intersect(array2,char(array1));
but no luck.
However, if I try to…
Sarah
- 325
- 6
- 17
0
votes
1 answer
finding the intersection point of a circle with a line in autocad customization using vb.net
For my autocad customization, I need to find the intersection point of a circle with a line. Below is my code but it does not return me any intersection point.
There will always be at least one intersection point because of constraints imposed on my…
user5138182
- 11
- 1
- 4
0
votes
0 answers
Index Matching in R
I have two data sets (dataset1 and dataset2) with a different amount of rows. My goal is to match a column from dataset1 with another column from dataset2 and include three different columns from dataset2 that correspond with the matching column and…
Nick
- 833
- 2
- 8
- 11
0
votes
1 answer
Calculate percent of matches between an array of values and a whitelist array
I'd like to make a website where users can find recipes by ingredients. How do I check how much an array matches another in percent?
To be more specific:
Pizza 1 contains cheese, tomato, ham, pineapple and beef.
Pizza 2 contains cheese, tomato,…
0
votes
2 answers
Oracle Intersection of rows in a Table
Hi I have a table with two columns (WID,DT) with data..
WID DT
-------
A 10
A 11
A 12
B 10
B 11
C 10
C 13
If I pass A,B in input i should get output as 10 and 11. Intersection of DT.
If I pass A,B,C in input I should get 10 as…
user5073139
- 1
- 1
- 1
0
votes
0 answers
c# XNA collesion slows movement
I'm busy with a C# XNA 4.0 2d rpg game and have the following problem.
To detect collesion i loop through all my TileStore objects stored in a List
TileStore is an object that holds:
Rectangle
Bool walkable
Bool pickable
But after some collesion…
Bham
- 309
- 5
- 21
0
votes
0 answers
R error: "all entries of 'x' must be nonnegative and finite" leading to incomplete intersect of data
I am intersecting two files and afterwards doing a fisher test and an enrichment test on the results. However after running the fisher test there is an error which I do not understand.
> ee=c()
> E=c()
> for (e in 1: length(conditions))
+ {
+ …
Jakobijn Strobbe
- 1
- 2
0
votes
1 answer
raycaster Intersection isn't accurate after moving vertices
I'm having issue with raycaster.intersectObjects() after moving vertices of a geometry.. It doesn't intersect with the new geometry, it only intersects with the part that overlaps the original area. The object looks correctly modified in the view.…
user3591153
- 409
- 4
- 14
0
votes
2 answers
scala partial string match
I have a question about List of Strings partial Matching to a List of Strings (intersect I guess).
List1:List = [a,b,c,d,e,f]
List2:Iterable[String] = [a b,e f,g h,x y]
I want to take any element or combination of elements in List1 that also…
GameOfThrows
- 4,510
- 2
- 27
- 44
0
votes
1 answer
Finding the points where a circle intersects another circle
In Java programing, if we have intersecting circles, one with center point O(x1,y1) and radius R1, and another with center point O'(x2,r2) and radius R2, how do we find points A and B where they intersect?
Nguyen Cuong
- 11
- 4
0
votes
0 answers
Three.js: polyhedron click (raycaster intersect)
I'm making a Three.js application and I want to catch clicks on objects. When I create cube or sphere everything is ok, but I fail with polyhedron - Raycaster.intersectObjects() returns empty result.
My code is below (see click events in…
Somerussian
- 381
- 4
- 17