15
I have a table which stores in each row a meeting with start date/time and end date/time.
meetingID int
meetingStart datetime
meetingEnd datetime
Desired output:
For each pair of overlapping rows I would like to output
meetingID, meetingStart, meetingID, meetingEnd
What's the most efficient way to perform such a query in MySQL?