The SQL intersect operator returns rows that are common between two tables without returning duplicate records.
Questions tagged [intersect]
643 questions
0
votes
2 answers
operations with structure in matlab
I have a structure 1x300 called struct with 3 fields but I'm using only the third field called way. This field is, for each 300 lines, a vertor of index.
Here an exemple with 3 lines to explain my problem : I woud like to search if the last index…
Mac.
- 303
- 1
- 12
0
votes
1 answer
VBA Module: Use the function "Intersect" for multiples ranges
I would like to get some feedback how to write my desired VBA module.
In my file I have multiple columns in which the values are changing as new data is collected from an external source (Bloomberg). Next, I would like to get a message if one of…
HJA24
- 410
- 2
- 11
- 33
0
votes
1 answer
Sqlite3: Selecting from multiple tables without duplicates
I've got three tables:
paper: items: attachments:
============ ============== ==============
jkey | title itemID | jkey* itemID* | path
*foreign key from another table
I'm trying to retrieve the…
tetris11
- 817
- 2
- 11
- 27
0
votes
1 answer
R: Find all overlaps in data frame
I have a dataframe (sample below) that has repeating data. The first column is the data from which the sample data was taken. I would like to create a table that calculates the number of overlaps in each possible intersection between the dates. In…
Z_D
- 797
- 2
- 12
- 30
0
votes
2 answers
How to work around a matrix dimension error with funtion intersect?
I have a 1000x1000 matrix A (containing values from 0 to 150) and a 181x1 vector B. In my matrix A, I want to keep only those values that are present in B while keeping A with the same size.
I tried with the function ismember but it doesn't give…
Mac.
- 303
- 1
- 12
0
votes
2 answers
How to IntersectSet of two NSDictionary or NSMutableDictionary with values?
Want to merge two NSDictionary or NSMutableDictionary only with dict1 values. like [NSMutableDictionary addEntriesFromDictionary:] and intersectSet (from NSMutableSet).
Dict 1 = @{@”One”: @””, @”Two”: @”"}
Dict 2 = @{@”One”: @”1”, @”Two”: 2,…
Mathi Arasan
- 869
- 2
- 10
- 32
0
votes
2 answers
Combine or Intersect Multiple MySQL Commands
I have to search on two tables.
My second table is:
+---------+---------------+-------+
| user_id | is_first_time | score |
+---------+---------------+-------+
| 44 | 1 | 20 |
+---------+---------------+-------+
| 44 | …
Bayu
- 437
- 2
- 10
- 19
0
votes
1 answer
Query between Interval Dates
I have the following table.
I am trying to get the records that intersects with any date, for example If I need the percent between 2002-12-29 and 2002-12-30 I should to get the first record with percent 28.60, I write a query but sometimes I get…
Alexander Ceballos
- 750
- 2
- 20
- 36
0
votes
3 answers
Integer array intersection recursion without loop
In my latest assignment I am supposed to find the intersection between two integer arrays using recursion and no loops (probably also no specialized methods but it didn't specify).
Input Arrays
[1, 4, 4, 5, 8, 19, 23, 42, 73]
[1, 4, 5, 9, 17,…
Kusko25
- 11
- 3
0
votes
1 answer
How to draw Intersection of line and solid object in BricsCAD
It is posible to set up BricsCAD in 3D to automatically create intersection points or intersection line during drawing line going through surface (in my case there are two points inner and outer surface or short line inside)? I would like to use…
hariprasad
- 555
- 11
- 20
0
votes
1 answer
SQL Request Intersect and EXISTS
I would like to know if the following request can be written with INTERSECT and EXIST keywords. My teacher asked me to solve a problem but I managed to do it only this way.
The technology used is Oracle.
The tables:
COMPUTER(id, name, ip, type,…
x84x4
- 19
- 4
0
votes
1 answer
Match nodes with common nodes with a relationship - Neo4j Cypher
I have number of User nodes and Skills nodes. The relationship is between skills and users.
USING PERIODIC COMMIT 1000
LOAD CSV WITH HEADERS FROM "file:/xyz.csv" AS row FIELDTERMINATOR '|'
WITH row
LIMIT 15
CREATE (u:User {company: row.company,…
user2558013
- 13
- 4
0
votes
0 answers
alternative to intersect operation in mysql
When I try below code I got error like
"ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'intersect
select sc1.section_identifier,sc2."
and I…
Dkyo Jeong
- 25
- 2
0
votes
1 answer
intersect stacked images R
I downloaded 50 landsat 8 images and extracted them in a subfolder Landsat8
By iterating through the list of folders containing the images I extracted 2 bands to calculate a vegetation index (LSWI) with a function created and called calcIndex:…
Jobbo90
- 175
- 1
- 11
0
votes
2 answers
sql intersect with dynamic input set
I'm trying to figure out how to get the intersection of a dynamic input set. Here is a very simplified example.
company_status table:
COMPANY | STATUS
----------------
Big | 1
Notused | 0
Small | 1
company_country table:
COMPANY |…
Matt
- 828
- 8
- 25