How to merge records with same columns by expanding time range??

Question

SQL

How to merge records with same columns by expanding time range??
Table example.
| id | date_from | date_to | param1 | param2 |
|
_
_
_
_

_
_ id | date_from | date_to | param1 | param2 |
1 2009 2012 'A' 'A'
1 2013 2014 'B' 'B' 1 2015 2018
'A' 'A'

dense_rank() over(partition by id order by param1, param2) as rnk,
*
from
Table

Answer 1

Wouldn't it work with normal grouping?

SELECT id, MIN(date_from), MAX(data_to), para1, param2 FROM table GROUP BY id, param1, param2