SQL Developer, aide pour une requête

Bonjour,

Je dois écrire la requête suivante :

Citation:

---

Quel est l'article (référence, désignation) le plus vendu

---

Or aucune de mes requêtes ne marchent...
Mon schéma est le suivant :

Citation:

---

Rayon (codeRayon, nomRayon)
Salarie (codeMatricule, nom, prenom, cAffaires, responsable, codeRayon)
Facture (numFacture, dateFacture, nomClient, codeSalarie)
Article (reference, designation, prixCatalogue, prixMinimal, qteStock, codeTVA, codeRayon)
TVA (codeTVA, tauxTVA)
DetailFact (Facture, reference, quantite, prixVente)

---

Pouvez-vous m'aider s'il-vous-plaît ?
Les requêtes que j'ai essayées :

Code:

---

1 2 3 4 5 6 7 8 9 10 11 12 13 14

Select designation, referencre from article where (SELECT reference, SUM(quantite) as nbv FROM detailfact GROUP BY reference HAVING SUM(quantite) >= ALL (SELECT SUM(quantite) FROM detailfact GROUP BY reference)) = (Select Max(nbv) From (select nbv, reference From ( SELECT reference, SUM(quantite) as nbv FROM detailfact GROUP BY reference HAVING SUM(quantite) >= ALL (SELECT SUM(quantite) FROM detailfact GROUP BY reference)))

---

Ou encore :

Code:

---

1 2 3 4 5 6 7 8

Select Max(nbv) From (select nbv, reference From ( SELECT reference, SUM(quantite) as nbv FROM detailfact GROUP BY reference HAVING SUM(quantite) >= ALL (SELECT SUM(quantite) FROM detailfact GROUP BY reference)))

---

Merci d'avance !

essai ça :

Code:

---

1 2 3 4 5 6 7 8

SELECT reference, designation FROM( SELECT A.reference, A.designation, sum(D.quantite) AS nbv FROM Article A, DetailFact D WHERE A.reference = D.reference GROUP BY A.reference, A.designation, D.quantite ORDER BY nbv DESC) WHERE ROWNUM=1;

---