mardi 10 février 2015

I need help in querying Database in etracting data which is present in rows as columns


Below is the format present in DB xmlid seqnbr levelid code 05 01 a 1 05 01 a 2 05 01 a 3 05 01 b 1 05 01 b 2 05 01 b 3 05 02 a 4 05 02 a 5 05 02 a 6 05 02 b 4 05 02 b 5 05 02 b 6


Desired result :


xmlid seqnbr levelid_a code1 code2 code3 levelid_b code1 code2 code3 05 01 a 1 2 3 b 1 2 3 05 02 a 4 5 6 b 4 5 6





Aucun commentaire:

Enregistrer un commentaire