I have a table "agenda" like this
| PERID | DAYNUM | START_HOUR | END_HOUR |
|---|---|---|---|
| 100 | 3 | 08:00 | 11:00 |
| 100 | 3 | 13:00 | 15:00 |
| 100 | 3 | 16:00 | 18:00 |
And I need, with a select, to get the "free" hours of the agenda like this:
| START_H | END_H |
|---|---|
| 11:00 | 13:00 |
| 15:00 | 16:00 |
Do you have an idea on how to write the select to get this result?
Already thank you to be interested on my query.