I think you might want interval packing
Thanks. I think I'll try to group using LEAD() and apply a grouping number using DENSE_RANK().
@dst2 started
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
I think you might want interval packing