1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| SELECT Number ,
max(case coord when 'TR' then x_nad end) AS tr_x_nad,
max(case coord when 'TR' then y_nad end) AS tr_y_nad,
max(case coord when 'TR' then z_nad end) AS tr_z_nad,
max(case coord when 'TR' then x_gr end) AS tr_x_gr ,
max(case coord when 'TR' then y_gr end) AS tr_y_gr ,
max(case coord when 'TR' then z_gr end) AS tr_z_gr ,
max(case coord when 'PP' then x_nad end) AS pp_x_nad,
max(case coord when 'PP' then y_nad end) AS pp_y_nad,
max(case coord when 'PP' then Z_nad end) AS pp_z_nad,
max(case coord when 'PP' then x_gr end) AS pp_x_gr ,
max(case coord when 'PP' then y_gr end) AS pp_y_gr ,
max(case coord when 'PP' then z_gr end) AS pp_z_gr ,
max(case coord when 'AP' then x_nad end) AS ap_x_nad,
max(case coord when 'AP' then y_nad end) AS ap_y_nad,
max(case coord when 'AP' then z_nad end) AS ap_z_nad,
max(case coord when 'AP' then x_gr end) AS ap_x_gr ,
max(case coord when 'AP' then y_gr end) AS ap_y_gr ,
max(case coord when 'AP' then z_gr end) AS ap_z_gr
FROM COORD
GROUP BY Number; |
Partager