Hi
I have data in following format:
I am trying to write a query where I can provide two period_names and it will fetch all period names between them.
e.g. if I provide input as May-21 to Feb-21, it should return me
I can achieve this using case statements in where clause, but is there any better approach may be using some hierarchical or recursive queries to achieve this.
Thanks.