1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| WITH
T_VAL AS
(SELECT 4 from dual AS V UNION ALL SELECT 21 from dual AS V UNION ALL SELECT 30 from dual AS V UNION ALL SELECT 5 from dual AS V UNION ALL SELECT 23 from dual AS V),
T_COMB AS
(SELECT T1.V AS V1, T2.V AS V2, T3.V AS V3, T4.V AS V4, T5.V AS V5
FROM T_VAL AS T1
CROSS JOIN T_VAL AS T2
CROSS JOIN T_VAL AS T3
WHERE T1.V <> T2.V AND T1.V <> T3.V AND T1.V <> T4.V AND T1.V <> T5.V
AND T2.V <> T3.V AND T2.V <> T4.V AND T2.V <> T5.V
AND T3.V <> T4.V AND T3.V <> T5.V
AND T4.V <> T5.V)
SELECT T.*
FROM matable AS T
INNER JOIN T_COMB AS C
ON T.colonne1= C.V1
AND T.colonne2= C.V2
AND T.colonne3 = C.V3
AND T.colonne4= C.V4
AND T.colonne5= C.V5; |
Partager