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

0 vote227 views1 answer
Mssql find deadlocks
SQL
0 vote253 views1 answer
Pl sql round
SQL
4 votes188 views3 answers
Sql drop database if exists
SQL
0 vote183 views1 answer
Get records in sql according to month name and count
SQL
54 votes556 views6 answers
Sql rename column
SQL
1 vote235 views1 answer
Homebrew install mysql
SQL
0 vote271 views2 answers
Fanyi
SQL
-1 vote200 views1 answer
Mysql select all columns and specific fields as
SQL
1 vote146 views1 answer
Mssql string length
SQL
0 vote202 views1 answer
Write a PL/SQL to print even numbers upto 100.
SQL