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

1 vote133 views1 answer
Sql server locks
SQL
1 vote118 views1 answer
How to get mysql db size
SQL
0 vote87 views1 answer
Calculate discount from original price sql
SQL
0 vote122 views1 answer
Docker export psql sql
SQL
1 vote172 views1 answer
Postgres set sequence value to max id
SQL
1 vote129 views1 answer
Group_concat order by
SQL
1 vote121 views2 answers
Into sql
SQL
1 vote123 views2 answers
Sql for date greater than
SQL
0 vote147 views1 answer
Import sql inside hide sql
SQL
0 vote121 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL