Window ?

Hi,

I have a road segment table with a few attributes for each. For each
segment, I have a road index and a segment index something like :

road seg colA

1 1 att1

1 2 att2

1 3 att3

1 4 att4

2 1 att5

2 2 att6

I want to convert records into lines,

1 att1 att2 att3 att4

2 att5 att6 ...

I was considering using window function, with a partition on road but the
problem is that segment count is different for each road, up to 30. So it's
seems a bit rough to write something like

select nth_value(colA,1), nth_value(colA,2), nth_value(colA,3),
nth_value(colA,4)...

Of course I can write a script with a loop to insert segments one road after
the other, but before going to this, I would appreciate a smarter idea !

Thanks

---
L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel antivirus Avast.
https://www.avast.com/antivirus