i have the following view
WOWO_EQUIPMENT WOWO_DECLARATION_DATE WOWO_END_DATE
-------------------- ------------------------- -------------------------
11101 10/04/24 14/04/24
11101 11/04/24 13/04/24
11101 13/04/24 15/04/24
11101 01/04/24 03/04/24
11101 02/04/24 04/04/24
11101 03/04/24 05/04/24
11101 07/04/24 09/04/24
MOTOFIX 09/04/24 09/04/24
need a select with the following results
WOWO_EQUIPMENT WOWO_DECLARATION_DATE WOWO_END_DATE
-------------------- ------------------------- -------------------------
11101 01/04/24 05/04/24
11101 07/04/24 09/04/24
11101 10/04/24 15/04/24
MOTOFIX 09/04/24 09/04/24
is it possible? my brain is burned i tried everything i found on internet even chat gpt
Thank you
i tried inner join as users said but it return only the overlapped dates, also i tried lead() but didnt help me a lot.
New contributor
Pavlos Koutsoukos is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1