Panowie i Panie taka sytuacja :)
id | data od | data do | typ | rozmiar|
---------------- | -------------------
1 | 2010-01-01 | 2012-01-01 0000.000 | 15 | 12
1 | 2010-01-01 | 2012-01-01 0000.000 | 15 | 15
1 | 2010-01-01 | 2012-01-01 0000.000 | 16 | 18
1 | 2010-01-01 | 2012-01-01 0000.000| 17 | 25
2 | 2010-01-01 | 2012-01-01 0000.000 | 15 | 23
2 | 2010-01-01 | 2012-01-01 0000.000 | 16 | 12
2 | 2010-01-01 | 2012-01-01 0000.000 | 17 | 15
3 | 2010-01-01 | 2012-01-01 0000.000 | 15 | 16
3 | 2010-01-01 | 2012-01-01 0000.000 | 16 | 18
A dążymy do tego:
id | data od | data do | typ15 | typ16 | typ17 |
---|---|---|---|---|---|
1 | 2010-01-01 | 2012-01-01 | 12 | ||
1 | 2010-01-01 | 2012-01-01 | 15 | ||
1 | 2010-01-01 | 2012-01-01 | 18 | ||
1 | 2010-01-01 | 2012-01-01 | 25 | ||
2 | 2010-01-01 | 2012-01-01 | 23 | ||
2 | 2010-01-01 | 2012-01-01 | 12 | ||
2 | 2010-01-01 | 2012-01-01 | 15 | ||
3 | 2010-01-01 | 2012-01-01 | |||
3 | 2010-01-01 | 2012-01-01 | 16 | ||
3 | 2010-01-01 | 2012-01-01 | 18 |
No mi już spędza sen z powiek, w excelu spoko ogarniam ale w SQL???