jyoubun1119

SQL大まかな順序

SELECT
FROM
WHERE
ORDER

SELECT Sum(tannka * suuryou) AS uriage FROM uriagemeisai
GROUP BY syouhinnmei;

Group by は集計関数とセットで使うSum Avg Count(shoubhinnmei) Max