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
How to calculate intersect of elements of a list in R
I have 10 lists named : Thre1, Thre2, Thre3, ..., Thre10.
My output should also be a list in a way that ith element of the output should be intersect of ith elements of my input lists so for example:
output[[1]] = Reduce(intersect,
…
hora
- 845
- 5
- 14
- 25
0
votes
1 answer
Avoiding duplicate entries in NHibernate
I am trying to store messages that I receive in a database using NHibernate. However, there is a possibility that the same message is received twice, and in that case I do not want to save the duplicate in the database. My first thought was to do…
Henry H
- 105
- 1
- 6
0
votes
1 answer
ADT LinkedList intersecting set error
I have a test code for an ADT of LinkedList, which implements interface NumList.java, and is implemented in a NumLinkedList.java, and am using it in a NumSet.java.
I am trying to make it so that my NumSet has methods where I can create a set from a…
Sukwoo
- 205
- 2
- 5
- 9
0
votes
1 answer
Linq to Sql Chained Intersect
I can't figure out why this isn't intersecting all of the items in the loop, just the last 2. I think it has something to do with IQueryable
var outerquery = db.Employees.Where(x => x.Name = "Smith").Select(x => x.EmployeeID);
foreach(var name in…
Alex
- 136
- 1
- 2
- 9
0
votes
1 answer
Counting rows where a column may different values
I have a table like the following:
id letter number
1 A 1
2 A 2
3 A 3
4 B 1
5 C 1
6 C 2
I need to count the number of id's where the letter A has a number 1 OR 2. That's the easy…
0
votes
1 answer
ray intersect planes with dynamic geometry returns empty array
* SOLVED *
It was not about 0,0,0 or distortion. It´s super weird but I found out that compute geometry as a Sphere worked! (even at the tiles corners, where you should think a sphere wouldnt cover it…
martinlindelof
- 111
- 6
0
votes
1 answer
SQL Server: Seperate queries return in less than a second but combining those with INTERSECT takes 3 mins
I'm not sure if this is an SQL Server bug or my mistake but here is the situation:
QUERY 1
select PK FROM PI_INFORM WHERE RECORD_DATE>DATEADD(hour,-48, GETDATE())
this takes less than 0.5 secs and returns 20,000 records
QUERY 2
SELECT PK FROM…
meraydin
- 89
- 1
- 1
- 11
0
votes
2 answers
Select all Items which intersect
I would like to get all values which Intersect from this LINQ query:
Where(x => x.Attribute("name").Value).Intersect(myList).Any();
I don't know how to add a select.
Daniel Camacho
- 423
- 5
- 12
- 27
0
votes
2 answers
How to set a range as the intersection of UsedRange WITHOUT first row + Another Column?
I have a range variable "rng".
I need to set rng to be the intersection of:
(1) The usedrange on the sheet EXCLUDING the first column, AND
(2) Column number 6, for example
Currently, I have:
Set rng = Intersect(.UsedRange,…
Alaa Elwany
- 677
- 7
- 15
- 20
0
votes
1 answer
Android: Find intersection points of a line and an image
Let's say I know two points that make up a line. I want to know the points in which this line goes through a matrix or a drawable of an image (both of which I have access to, so whichever one would be easier to use is welcome). Any ideas on how I…
ElectronAnt
- 2,115
- 7
- 22
- 39
0
votes
1 answer
SQL query to intersect
I'm having a lot of issues with SQL, I'm not sure how to do what I need, but the series of steps is this:
Have two tables.
Table 1 has a 'game_id'
Table 2 has a 'game_id' and 'id'
Where 'game_id' is the same as the first table.
Table 1 is a list…
Adola
- 588
- 7
- 21
0
votes
2 answers
How to use intersect (and maybe minus) on this example
lets say I have two tables:
TableA
ID, Time, Size
0 5:00 600
1 8:00 800
2 7:00 100
3 1:50 140
4 2:40 300
12 3:40 300
TableB
ID, Time, Size
8 5:00 600
1 8:00 800
2 8:00…
sabisabi
- 1,501
- 5
- 22
- 40
0
votes
0 answers
Fetching results from one table and put the corresponding values in another table
I was searching for a result, but I didn't find proper solutions.
So, I will put my problem across. Please tell, if its already listed in any of the topics !
I have one table, table123, which has columns like,…
Manikandan
- 417
- 4
- 8
- 18
0
votes
1 answer
SQLite Delete from New Table data that exists in old table
I get daily update files of progress on a project that have no date field. I have added a date column to the first Table and imported the 1st and 2nd tables into SQLIte. Now I want to delete from the 2nd table, data that already exists in the 1st…
Arveedar
- 3
- 1
-1
votes
1 answer
Matching two columns
I have a two tables. TableA has two columns and TableB has one column.
TableA
ID | TERM_A
TableB
TERM_B
TERM_A and TERM_B column contain terms .
I want to take intersect terms from TERM_A column of TableA and TERM_B column of TableB with…
user951487
- 845
- 7
- 19
- 30