Exploration mono-dimension et mono-niveau avec GROUP BY
Syntaxe :
1
SELECT d.att, COUNT(*) AS q
2
FROM facts f, dim1 d
3
WHERE f.fk=d.pk
4
GROUP BY d.att
5
ORDER BY q desc;
Exemple :
1
SELECT d.jds, COUNT(*) AS q
2
FROM ventes v, date d
3
WHERE v.dat=d.dat
4
GROUP BY d.jds
5
ORDER BY q desc;