I have a table that has some ranges per each client. I need these ranges to have no overlap (with at least 0.01 diff between max of higher row and min of lower row).

**Example:**

```
| Client | min | max |
|--------|-----|-----|
| A      |   1 | 2.5 |
| A      |   2 | 3.5 |
| A      | 3.5 |   4 |
| B      |   1 |   2 |
| B      |   3 |   5 |
| B      | 4.5 |  10 |

```

I need this data to look like this:

```
| Client | min  | max |
|--------|------|-----|
| A      |    1 | 2.5 |
| A      | 2.51 | 3.5 |
| A      | 3.51 |   4 |
| B      |    1 |   2 |
| B      |    3 |   5 |
| B      | 5.01 |  10 |

```

Do I need to use window function? Appreciate any help.