The SQL intersect operator returns rows that are common between two tables without returning duplicate records.
Questions tagged [intersect]
643 questions
2
votes
1 answer
Using INTERSECT with tables from a WITH clause
What is wrong with this query:
WITH volcan AS (SELECT DISTINCT v.numturista
FROM viaje v, sitio s
WHERE v.numsitio = s.numsitio
AND s.tipo = 'Volcan'),
desierto AS (SELECT DISTINCT v.numturista
…
blaze
- 2,588
- 3
- 32
- 47
2
votes
1 answer
Flash automatically finds curve intersection points. Can I use that code like I use curveTo in actionscript?
Or do I have to get down and dirty with the math and do the spline intersection math myself? I know the basic math for Quadratic b-splines.
I'm trying to make procedural randomly generated Celtic knot-work that animates itself. I'm inspired by the…
user2246225
- 21
- 1
2
votes
1 answer
How to get an interesect query using CritieraQuery?
Given
@Entity
public class Document {
@Id
@Column(name = "DOCUMENT_ID")
private Long id;
@ElementCollection
@CollectionTable(
name="TAG",
joinColumns=@JoinColumn(name="DOCUMENT_ID")
)
…
Tomasz
- 5,269
- 8
- 56
- 65
2
votes
1 answer
PostGIS: ST_Intersects() between two geographies, sometimes returns false result
I have a problem with an intersect between two geographies in PostGIS:
I have a table1 with a geography-column, filled with multi-polygons in wgs84 (one per line).
A second table2 also has a geography-column filled with multi-polygons in wgs84 (one…
David Leimbach
- 21
- 2
2
votes
2 answers
trying to match a value in two arrays, if a matched value is present then output true
trying to match a value in two arrays, if a matched value is present then output true, thinking maybe the array_intersect function? very unsure! Any help is much appreciated!
Basically have two sql queries which i cant quite fit into this box! but…
Findlay Mack
- 25
- 1
- 4
2
votes
0 answers
Intersect between some DbGeography elements doesn´t work with Entity Framework 5
What is wrong with that??
const string lonMin="-19";
const string latMin = "25";
const string lonMax = "-24";
const string latMax = "25.6";
//Create a polygon
var geoEncuadre = DbGeography.FromText("POLYGON ((" + lonMin + " " + latMin + ","…
Pedraz
- 148
- 1
- 9
2
votes
0 answers
Grouping an array with intersecting dates for calendar day view
Doing a personal project, making a calandar with just php. I simply cannot figure out a way to group arrays based on intersecting dates so that I can draw them on a grid. Something that looks like…
Charleston Olaes
- 21
- 1
2
votes
1 answer
Awk matching between two files when regions intersect (any solutions welcome)
This is building upon an earlier question Awk conditional filter one file based on another (or other solutions)
Quick summary at bottom of question
I have an awk program that outputs a column from rows in a text file 'refGene.txt if values in that…
user964689
- 812
- 7
- 20
- 40
2
votes
2 answers
SELECT Statement using INTERSECT
I have two tables: tblProduct which has list of Products, and tblConsumer which has consumer name with consumed product ID.
Now I need to find the name of consumers who have consumed all products from the product table.
I tried to solve this with…
Shai
- 529
- 7
- 20
- 36
2
votes
2 answers
MYSQL getting the difference of two results
ok so my problem is that I have a set of results:
ID CODE
1 A
1 B
3 C
I also have another table of:
CODE
A
B
C
What I want to get using SQL is a query of CODES that each result from table 1 is missing. So basically:
ID CODE
1 C
3 …
user1577584
- 21
- 1
2
votes
3 answers
intersect cassandra rows
We have cassandra column family.
each row have multiple columns. columns have name, but value is empty.
if we have 5-10 row keys, how we can find column names that appear in all of these keys.
e.g.
row1: php, programming, accounting
row2: php,…
Nick
- 9,962
- 4
- 42
- 80
2
votes
2 answers
LINQ Intersect but add the result to a New List
I have a list called DiscountableObject. Each item on the list in turn has a Discounts collection. What I need is a list of Discounts which are common across all DiscoubtableObjects.
Code:
List IntersectionOfDiscounts = new…
Magic
- 137
- 1
- 8
1
vote
2 answers
How can I identify multiple word tags in a text field in SQL
I would like to have a SQL procedure which can be passed a text string and it will identify specific keywords (tags) in the text from a table of keywords.
So far I have the following which works really nicely for single words;
INSERT INTO #tags…
Mojo
- 21
- 3
1
vote
1 answer
how to write query for retrive common data
Possible Duplicate:
Intersect in mysql
I have do a php project for retrieving common data.I am little weak in writing MySQL query. i was tried different ways .But i cannot get proper output
My table is
Id Product-1 product-2
…
Vineeth
- 57
- 2
- 2
- 8
1
vote
1 answer
Alternative to `ismember` and `intersect` in Matlab to perform the task of comparison?
I have 100 models (matrices), where each matrix's size is 4X3. Each of the four variables R_L, N_g, N_Pc, and uT are of size 4x3x100, where 4X3 is size of each matrix and there are 100 of such matrix. I have attached a snapshot of two variables to…
user238469