SQL Developer, aide pour une requête

[minimoy]

Bonjour,

Je dois écrire la requête suivante :

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 :

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 !

[moman]

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;