Stack Overflow
Stack Overflow

Questions tagged [intersect]

The SQL intersect operator returns rows that are common between two tables without returning duplicate records.

643 questions
0
votes
1 answer

Haskell Multiset Operations

I am trying to create functions which can find the union and intersection of two multi sets in Haskell without the use of the Multiset module. I have a good understanding of basic intersections and unions in normal lists but multisets seem to throw…
user6040924
0
votes
2 answers

SQL intersection - error in syntax

I am trying search for flights departing from London and Arriving in Paris. The information about the cities are located in the Airport table, while the abbreviations for the departing and arriving airports are located in Flight. Here's my code for…
Sick0ne
  • 23
  • 1
  • 1
  • 4
0
votes
1 answer

Intersect sorts out the results alphabetically c#

Alright so this is my first question here at stack. So i have the current code (Note im using c#)- public static void ReadSuburbs() { String directory = @"C:\Address Sorting\"; String[] linesA =…
Dillon Munien
  • 15
  • 5
0
votes
1 answer

Need only common nodes across multiple paths - Neo4j Cypher

sMy Cypher query finds the common child nodes for several starting nodes. Each path has only it's node id's extracted and returned resulting in hundreds of rows in each path. See p1 and p2 example (showing only 3 rows and two start points). Match…
Damon
  • 83
  • 8
0
votes
1 answer

C# how to find the value of given coordinate of x,y in two dimension array

i'm going to try explain my question again. I have a matrix like that Int32[,] coordinate = new Int32[5, 5]; I'm printing that with thesee codes. for (int i = 0; i < 5; i++) { for (int j = 0; j < 5; j++) { …
Nezih
  • 381
  • 6
  • 19
0
votes
0 answers

Find nearest point of two 3D lines that do not intersect using R

I am performing an Xray investigation where I want to find coordinates for radioopaque markers in a 3D-space. Using a C-arm, I acquire two images of the same marker, one from bottom-to-top and one from the side. From the Xray source (P1 in…
kruemelprinz
  • 35
  • 6
0
votes
1 answer

Single table INTERSECT alternative

I am currently working on a system to allow documents to be tagged with keywords and have a table of the form: CREATE TABLE `KeywordsToDocuments` ( `keywordID` int NOT NULL, `documentID` int NOT NULL); It is possible for each document to be…
Vality
  • 6,577
  • 3
  • 27
  • 48
0
votes
1 answer

Common Points in an array of rectangles

Deveoping a function that finds a common intersection between an array of rectangles however the method return False when it should be true. The function calls to the intersect function in the class rectangle. Any suggestions. Class Rectangle: …
Stephanie
  • 47
  • 5
0
votes
1 answer

Java-Algorithm for Polygon-Collision (Point-in-Polygon): Problems with Degenerated @ Boundary

I need for my java-program a function that checks for polygon-collision, but the algorithms (for point-in-polygon) I tried were not correct for my needs, the degenerative cases are a problem for me. This is what i try to reach with my program: I…
E.B.
  • 1
0
votes
2 answers

How to INTERSECT datas from tables on postgres

I'm having some problems with INTERSECT command. Hope someone could help me. I want to get the the movieid that appears in the first and second SELECT. After that I want to use these data (that could be in a LIMIT of 10) to receive the titles of the…
Léo Eduardo Silva
  • 131
  • 11
0
votes
2 answers

Python 2.7 - Intersect Unicode Dictionary with Unicode List

I'm trying to work with the sets and the intersect method to find which elements in a unicode list of file paths have specific characters in them. The goal is to replace these characters with other characters, so I've made a dictionary of keys and…
Crazy Otto
  • 125
  • 2
  • 13
0
votes
2 answers

Matrix query using INTERSECT

I have data that represents real-world physical locations. Conceptually, one could look at it as: |--|---|---|---|---|---| |1A| 2A| 3A| 4A| 5A| 6A| |--|---|---|---|---|---| |1B| 2B| 3B| 4B| 5B| 6B| |--|---|---|---|---|---| |1C| 2C| 3C|…
Meta Mussel
  • 548
  • 1
  • 5
  • 19
0
votes
0 answers

How to find the biggest triangle drawable between pre-existent lines

I have a rectangular plane filled with randomly drawn straight lines (of which i know the vertices coordinates), with different lenghts, and i need to find which triangles can i draw (possibly the biggest ones) inside it that intersecates with the…
KylesDev
  • 99
  • 1
  • 1
  • 9
0
votes
1 answer

Differences between joins and sets in sql?

What are the main differences between JOINS(INNER JOIN,LEFT OUTER JOIN, RIGHT OUTER JOIN etc.) and SET operations( INTERSECT, MINUS etc.) ?
Rajeev
  • 442
  • 1
  • 5
  • 18
0
votes
1 answer

Intersect two SQL statement in Yii?

I want to apply an intersect operator on two SQL queries, but I couldn't find any Yii method for it in CDbCommand. Is there any?
Pragya Dalal
  • 68
  • 2
  • 9
1 2 3
…
42 43