The SQL intersect operator returns rows that are common between two tables without returning duplicate records.
Questions tagged [intersect]
643 questions
-2
votes
2 answers
LINQ Intersect based on Property
I'm trying to find an intersect on two collection where the items overlap having an inverse state.
public class Sample
{
public int SampleNumber { get; set; }
public DateTime StartTime { get; set; }
public DateTime EndTime { get; set; }
…
7VNT
- 41
- 8
-2
votes
2 answers
Indices of intersecting rows of Numpy 2d Array
I want to get the indices of the intersecting rows of a main numpy 2d array A, with another one B.
A = array([[1,2],
[1,3],
[2,3],
[2,4],
[2,5],
[3,4]
[4,5]])
B = array([[1,2],
…
Gustavo Ugarte
- 17
- 6
-2
votes
1 answer
Extract non intersected element from a string vector in R
I have 2 string vectors, and I have intersected them in order to get the intersected string vector, but now, I need to get the 2 other string vectors without the intersected elements.
That is, vector.1 without intersected.vector elements, and…
Laure Tomás Daza
- 117
- 1
- 6
-2
votes
6 answers
C# Linq Intersect
Most of the time I just use foreach statements, because that is a lot easier for me to code.
Later on, when my code is done, I convert the foreach into LINQ statements where it makes sense.
I want to learn how to write good readable LINQ…
Tony_KiloPapaMikeGolf
- 879
- 12
- 28
-2
votes
1 answer
R: Find identical strings in two lists
I have two lists of strings and want to find which strings are in both lists.
I tried converting the lists to vectors so that I could use intersect or setequal but that converted all the strings to numbers and (apologies if there's an obvious answer…
Michael
- 9
- 1
- 2
-2
votes
1 answer
store the value to array, and select array intersected
1.I would like to store the array value to this three variable, and take the intersected value of it, but it did not work!
$report =array();
$report1 =array();
$report2 =array();
while ($row=mysql_fetch_array($r_query)){
echo 'Primary first…
-2
votes
1 answer
Dictionary Intersect by Value
I have two dictionary objects
I am trying to intersect DictA from DictB by their values and return a 3rd dictionary with the results
I am able to do this however this only produces a list of ints
var results =…
mrb398
- 1,277
- 4
- 24
- 32
-2
votes
2 answers
Need intersect point for a line coming from center of circle?
I have a line with start point as P1(x1, y1) & end Point as P2(x2, y2). This line is from the center of circle. The circle radius is r. Need a simple equation to identify the circle line intersect point?
balusu
- 367
- 3
- 10
-2
votes
4 answers
mysql : intersection between 3 or more SELECT's results
ok, suppose we have 3 or more let's say "k" tables with the same structure:table 1:
id customer_id
1 35
2 36
3 37
table 2:
id customer_id
1 35
2 38
3 39
...
table k:
id customer_id
1 35
2 69
3 52
how can i select all the customer_id…
-3
votes
1 answer
I cannot discover error, attempting to insert ...columns do not match
So the code runs until inserting new row, at which time I get>>>
'attempting to insert [ 3 item result] into these columns [ 5 items]. I have tried to discover where my code is causing a loss in results, but cannot. Any suggestions would be great.…
KVHarmon
- 1
- 2
-3
votes
1 answer
In SQL server, how to fetch column names from a source except target query for which data does not match
I have to find out the name of columns which have different data in a source except target query.
Currently when I am executing a Source except Target query, Even if there is only one column value is different, it's returning entire row. My…
Shashank
- 11
- 1
-3
votes
1 answer
Bubble in Graphic program
Hey all
I have a program that draw a bubble anywhere by touching the screen (gesture detector),
I want to handle an issue not to draw two bubbles at the same position by intersect method
how can I do that ?**
mervat
- 5
- 1