Skip to content
Advertisement

Sort by status and effective date range

Before After

Is there any way to make ‘Before’ to ‘After’? if a function or procedure is required, please write one for me. please help me

Advertisement

Answer

You just need to use GROUP BY and analytical function as follows:

User contributions licensed under: CC BY-SA
2 People found this is helpful
Advertisement