1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
| WITH t AS ( SELECT 1 Article, 'tee-shirt' lib FROM DUAL
UNION ALL SELECT 2 Article, 'chaussure noir' lib FROM DUAL
UNION ALL SELECT 2 Article, 'chaussure bleu' lib FROM DUAL
UNION ALL SELECT 3 Article, 'pantalon' lib FROM DUAL
UNION ALL SELECT 4 Article, 'casquette' lib FROM DUAL
UNION ALL SELECT 5 Article, 'chaussette basse' lib FROM DUAL
UNION ALL SELECT 5 Article, 'chaussette haute' lib FROM DUAL
UNION ALL SELECT 6 Article, 'chaussette basse' lib FROM DUAL
UNION ALL SELECT 7 Article, 'chemise' lib FROM DUAL)
SELECT art, MIN(lib)
FROM (
SELECT lib, MAX(article) art
FROM t
GROUP BY lib
)
GROUP BY art
ART MIN(LIB)
1 tee-shirt
2 chaussure bleu
3 pantalon
4 casquette
5 chaussette haute
6 chaussette basse
7 chemise |
Partager