Salut,

Am o tabela de genu:
ID phonenumber contact
1 29349245934 a
2 34953405823 a
3 34538458345 a
4 93459345394 b
5 54688456854 b
6 56786587856 c
7 54684568456 c
8 34858129349 c

Vreau sa scriu un query care sa-mi returneze
Contact PhoneNB1 PhoneNB2 PhoneNB3
a 29349245934 34953405823 34538458345
b 93459345394 54688456854
c 54684568456 34858129349

Ma puteti ajuta?am facut un while si cu pivot dar while dureaza enorm.

Thx,
Marius