Sql period overlap

-- table1          <-----row 1 interval------->
-- table2  <---find this--> <--and this--> <--and this-->

SELECT * 
FROM table1,table2 
WHERE table2.start <= table1.end 
AND (table2.end IS NULL OR table2.end >= table1.start)

Source: stackoverflow.com

Similar codes

13 votes112 views2 answers
Oracle all source
SQL
3 votes205 views2 answers
Enter mysql command line
SQL
20 votes169 views4 answers
Reset auto increment in MySQL
SQL
0 vote151 views4 answers
Restart MySQL
SQL
0 vote156 views1 answer
Cast as decimal postgresql
SQL
10 votes157 views1 answer
Oracle object dependencies
SQL
1 vote154 views1 answer
Postgresql must appear in the group by clause or be used in an aggregate function
SQL
0 vote160 views1 answer
Postgres sql alter table delete row
SQL
4 votes141 views2 answers
Postgresql reset sequence
SQL
0 vote197 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL