What is a simple and efficient way to find rows with time-interval overlaps in SQL?

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

More Related Contents:

  1. How do I create a parameterized SQL query? Why Should I?
  2. Auto Increment after delete in MySQL
  3. Left Join With Where Clause
  4. SELECT * EXCEPT
  5. Update table values from another table with the same user name
  6. Select max value of each group
  7. What is the string concatenation operator in Oracle?
  8. Using an Alias in a WHERE clause
  9. How can I define a composite primary key in SQL?
  10. How can I introduce multiple conditions in LIKE operator?
  11. How do I delete from multiple tables using INNER JOIN in SQL server
  12. Does Foreign Key improve query performance?
  13. SQL : BETWEEN vs =
  14. SQL query for finding records where count > 1
  15. Using sql function generate_series() in redshift
  16. SQL Server convert string to datetime
  17. How can I insert values into a table, using a subquery with more than one result?
  18. MySQL – Selecting data from multiple tables all with same structure but different data
  19. What is the equivalent PostgreSQL syntax to Oracle’s CONNECT BY … START WITH?
  20. Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)
  21. can we list all tables in msaccess database using sql?
  22. String concatenation does not work in SQLite
  23. Using alias in query and using it
  24. Comparison of Relational Databases and Graph Databases
  25. How do I view grants on Redshift
  26. The difference between ‘AND’ and ‘&&’ in SQL
  27. How to detect query which holds the lock in Postgres?
  28. Query a Table’s Foreign Key relationships
  29. How to get the next number in a sequence
  30. Get the first and last date of next month in MySQL

Leave a Comment