SELECT
COUNT(*),
ramByUcId.NBRAM
FROM
(
SELECT
uc.id_uc
SUM(contient.nb_ram*ram.type_ram/1000) AS NBRAM
FROM
uc
INNER JOIN
contient
ON contient.id_uc = uc.id_uc
INNER JOIN
ram
ON ram.id_ram = contient.id_ram
) AS ramByUcId
GROUP BY
ramByUcId.NBRAM
[quote=“mono, post:1, topic: 50927”]select uc.id_uc,sum(contient.nb_ram*ram.type_ram/1000) as NBRAM from uc,contient,ram where contient.id_uc=uc.id_uc and contient.id_ram=ram.id_ram GROUP BY uc.id_uc
J’aimerai regrouper ce résultat pour compter les uc ayant le même NBRAM [/quote]
c’est porc mais ca devrait marcher :
select count() as NbUC, A.NBRAM as NBRAM from (
select uc.id_uc,sum(contient.nb_ramram.type_ram/1000) as NBRAM from uc,contient,ram where contient.id_uc=uc.id_uc and contient.id_ram=ram.id_ram GROUP BY uc.id_uc) as A
Group by A.NBRAM