The SQL intersect operator returns rows that are common between two tables without returning duplicate records.
Questions tagged [intersect]
643 questions
0
votes
4 answers
Making a global variable
I'm making a game and I'm having trouble getting variables from another class. I have a Sprite class and a JPanel class. In my game, I want my score to go up once I hit a coin. My intersect coin code is in my Sprite class. How would I make it so…

user3542484
- 11
- 2
0
votes
1 answer
BackGround in my JPanel, how can I resolve this?
Well my problem is that I'm making the stars move with a thread, they move verticaly and it works good but i do a random X for the star and sometimes it intersecs other stars like this :
This is my code for the JPanel:
class Backgroundmoving…

Steven_95
- 75
- 8
0
votes
1 answer
MySQL Intersect on same table
My original query is:
SELECT * from test where ID BETWEEN 10 AND 100
INTERSECT
SELECT * from test where MARKS=10
But, INTERSECT is not working in MySQL
I am querying from the same table and INNER JOIN is not working.

user3353758
- 5
- 3
0
votes
1 answer
How to make my collision check with Intersect between rectangles to work?
EDIT:here is the full code: https://dl.dropboxusercontent.com/u/65678182/assignment1.rar Any possible help is highly appreciated!
I am trying to make a copy of the breakout game, but I have problems with checking if two objects (the ball and…

user3483682
- 51
- 1
- 7
0
votes
0 answers
MySQL ST_intersect doesn't work correctly
I have specific problem with MySQL ST_intersect function. MySQL ST_intersect doesn't work correctly in our case.
I'm asking for intersects between polygon and line like in example bellow:
SELECT ST_intersects( GeomFromText( 'POLYGON((0 10,10 10,10…

Martin Kotyk
- 1
- 1
0
votes
1 answer
how to find the area of intersect of Recangle2D in java
I have shapes beside each other, some of them are pasted twice on itself, i want to figure out which object is pasted through getting the percentage of intersection of 2 objects, i coded for comparing single object with all other objects, where i'll…

a14
- 31
- 15
0
votes
1 answer
Snake collision detection with itself
I am currently writing some simple snake game in java. The snake objects has an array full of bodyparts. these bodyparts all contain a rectangle.
the snake's update method is like that:
public void update() {
if(isMoving) {
…

user2410644
- 3,861
- 6
- 39
- 59
0
votes
1 answer
android sqlite help to fire my own query?
hello guys i have a simple intersect query works fine for sqlite3 console on windows
But how can i fire it and retrieve results in android sqlite database.
eg.
SELECT b_name FROM bus,route,station WHERE s_name='STAITON_NAME'
AND…

user3139338
- 1
- 1
0
votes
1 answer
Detect if polylines intersect polygon
I have some polylines (an array of coordinates, representing a route)
I also have a polygon (a rectanble made from 4 coordinates)
They are used in Google Maps (API v3).
--
I need to know if any of theese polylines intersect the polygon, and if so,…

Gertsen
- 1,078
- 20
- 36
0
votes
1 answer
Faster or smarter way to sort and intersect large amount of data?
I was using "intersect" in my Matlab code to do the sorting where I want the following:
[ch] = sort(s, 'ascend');
[same, a] = intersect(s, ch);
For example:
input:
s = [55 21 78 7]
output:
ch = [7 21 55 78]
a = [4 2 1 3]
I need to access a…

user2563812
- 219
- 1
- 2
- 12
0
votes
3 answers
VTK: Intersection between a plane and a polydata
Is there a simple way to compute whether a plane and a polydata-object intersect?
I want to know on which sides my polydata-object protude my bounding box.
I want to use VTK for this task.

liquid.pizza
- 505
- 1
- 10
- 26
0
votes
1 answer
Javafx - Cursor intersect shape
I have a few objects on a board and I'd like to get those objects's indexes by the coordinates.
I've tried making a MouseEvent handler and using the getBoundInParent() combined with MouseInfo.getPointerInfo().getLocation(), but unsuccessful. These…

Adorjan
- 39
- 9
0
votes
1 answer
How to intersect and differ multidimensional array
I have two arrays.
$paternalSiblings = fname => John lname => Doe gender => M birth_year => 1988
fname => Sophie lname => Ellison gender => F birth_year => 1990
$maternalSiblings = fname => John lname => Smith gender => M…
user2369628
0
votes
2 answers
Rectangle overloaded method issue
So I have a rectangle I am using for a bouncing box.. I'm bouncing balls of this rectangle so need to be able to check if it is bouncing off either the x or y axis of my rectangle. Originally I had the code following code which was fine for…

Rich
- 15
- 1
- 9
0
votes
1 answer
Union? Intersect? Or inversed intersect?
I'm working on a select statement that should return the class for each of the school days. There are 4 school days before the cycle starts over again. (e.g. Monday = Day1, Tuesday = Day2...Thursday = Day4, Friday = Day1..etc )
Some students may…

MPaul
- 2,553
- 3
- 20
- 34