Mysql – Squeeze records based on matching prior and current values
I'm working on a SQL solution to squeeze the number of rows when there are matching "start" and "close" values across records. Here is an example input and the required output Input name start close A 120 130 A 130…