1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| SELECT part1
, part2
, part3
, SUBSTRING(suite3 FROM 1 FOR POSITION(',' IN suite3) - 1) AS part4
, SUBSTRING(suite3 FROM POSITION(',' IN suite3) + 1) AS part5
FROM (
SELECT part1
, part2
, SUBSTRING(suite2 FROM 1 FOR POSITION(',' IN suite2) - 1) AS part3
, SUBSTRING(suite2 FROM POSITION(',' IN suite2) + 1) AS suite3
FROM
( SELECT part1
, SUBSTRING(suite1 FROM 1 FOR POSITION(',' IN suite1) - 1) AS part2
, SUBSTRING(suite1 FROM POSITION(',' IN suite1) + 1) AS suite2
FROM
( SELECT SUBSTRING(PCDWLD FROM 1 FOR POSITION(',' IN PCDWLD) - 1) AS part1
, SUBSTRING(PCDWLD FROM POSITION(',' IN PCDWLD) + 1) AS suite1
FROM ADELE.BALFIST
) AS tmp1
) AS tmp2
) AS tmp3 |
Partager