+—————+—————————–+——–+———————+-<\/strong><\/p>\nSELECT SUM(price) FROM sales;<\/pre>\n\u3010SELECT\u7d50\u679c\u3011<\/strong>
\nmysql> SELECT<\/span> SUM<\/span>(price) FROM<\/span> sales;<\/strong>
\n+————+<\/strong>
\n| SUM<\/span>(price) |<\/strong>
\n+————+<\/strong>
\n| 750000<\/span> |<\/strong>
\n+————+<\/strong>
\n1 row in set<\/span> (0.00<\/span> sec)<\/strong><\/p>\n\uff12-\uff12\uff0eNULL\u5024\u306e\u6271\u3044<\/span><\/h3>\nSUM\u95a2\u6570\u306f\u30c7\u30fc\u30bf\u306bNULL\u304c\u542b\u307e\u308c\u3066\u3044\u308b\u5834\u5408\u3001NULL\u3092\u7121\u8996\u3057\u3066\u5408\u8a08\u3092\u6c42\u3081\u307e\u3059\u3002
\n\u4e0a\u8a18\u306e\u30b5\u30f3\u30d7\u30eb\u30b3\u30fc\u30c9\u3067\u3082 price \u306b\u306fNULL\u306e\u30c7\u30fc\u30bf\u304c\u542b\u307e\u308c\u3066\u3044\u307e\u3059\u304c\u3001\u554f\u984c\u306a\u304f\u8a08\u7b97\u304c\u3067\u304d\u3066\u3044\u307e\u3059\u3002<\/p>\n
3\uff0eWHERE\u53e5\u3084GROUP BY\u3068\u306e\u7d44\u307f\u5408\u308f\u305b<\/span><\/h2>\n\u3067\u306f\u6b21\u306bWHERE\u53e5\u3084GROUP BY \u53e5\u3092\u4f7f\u3063\u3066\u6761\u4ef6\u3092\u7d5e\u3063\u3066\u307f\u307e\u3059\u3002<\/p>\n
\uff13-\uff11\uff0eWHERE\u53e5\u3067\u5408\u8a08\u306e\u5bfe\u8c61\u3092\u7d5e\u308b<\/span><\/h3>\nWHERE\u53e5\u3092\u52a0\u3048\u3001\u682a\u5f0f\u4f1a\u793eA \u3060\u3051\u306e\u5408\u8a08\u3092\u8a08\u7b97\u3057\u307e\u3059\u3002
\n\u682a\u5f0f\u4f1a\u793eA\u3060\u3051\u306e\u5408\u8a08\u3092\u8a08\u7b97\u3059\u308b\u3002
\n<\/span><\/p>\nSELECT SUM(price) FROM sales WHERE customer_name = '\u682a\u5f0f\u4f1a\u793eA';<\/pre>\n\u3010SELECT\u7d50\u679c\u3011<\/strong>
\nmysql> SELECT<\/span> SUM<\/span>(price) FROM<\/span> sales WHERE<\/span> customer_name = ‘\u682a\u5f0f\u4f1a\u793eA’;<\/span><\/strong>
\n+————+<\/strong>
\n| SUM<\/span>(price) |<\/strong>
\n+————+<\/strong>
\n| 450000<\/span> |<\/strong>
\n+————+<\/strong>
\n1 row in set<\/span> (0.00<\/span> sec)<\/strong><\/p>\n\u682a\u5f0f\u4f1a\u793eA\u3060\u3051\u306e\u5408\u8a08\u3092\u6c42\u3081\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n
\uff13-\uff12\uff0eGROUP BY\u53e5\u3068\u7d44\u307f\u5408\u308f\u305b\u308b<\/span><\/h3>\n\u3067\u306f\u6b21\u306bGROUP BY\u53e5\u3092\u4f7f\u3063\u3066\u9867\u5ba2(customer_name)\u3054\u3068\u306e\u5408\u8a08\u3092\u6c42\u3081\u3066\u307f\u307e\u3059\u3002
\n\u9867\u5ba2(customer_name)\u3054\u3068\u306e\u5408\u8a08\u3092\u6c42\u3081\u308b\u3002<\/span><\/p>\nSELECT customer_name, SUM(price) FROM sales GROUP BY customer_name;<\/pre>\n\u3010SELECT\u7d50\u679c\u3011<\/strong>
\nmysql> SELECT<\/span> customer_name, SUM(price) FROM<\/span> sales GROUP BY<\/span> customer_name;<\/strong>
\n+—————+————+<\/strong>
\n| customer_name | SUM<\/span>(price) |<\/strong>
\n+—————+————+<\/strong>
\n| \u682a\u5f0f\u4f1a\u793eA | 450000<\/span> |<\/strong>
\n| B\u682a\u5f0f\u4f1a\u793e | 270000<\/span> |<\/strong>
\n| C\u682a\u5f0f\u4f1a\u793e | 30000<\/span> |<\/strong>
\n+—————+————+<\/strong>
\n3 rows in set<\/span> (0.00<\/span> sec)<\/strong><\/p>\n\u9867\u5ba2\u3054\u3068\u306e\u5408\u8a08\u3092\u6c42\u3081\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n
\uff14\uff0e\u307e\u3068\u3081<\/span><\/h2>\n\n
\u30fbSUM\u95a2\u6570\u306f\u6570\u5024\u306e\u5408\u8a08\u3092\u6c42\u3081\u308b\u3053\u3068\u304c\u3067\u304d\u308b
\n\u30fbNULL\u306f\u7121\u8996\u3057\u3066\u8a08\u7b97\u3055\u308c\u308b
\n\u30fbWHERE\u53e5\u3084GROUP BY\u53e5\u3068\u7d44\u307f\u5408\u308f\u305b\u308b\u3053\u3068\u3067\u69d8\u3005\u306a\u96c6\u8a08\u304c\u53ef\u80fd<\/p>\n<\/div>\n
\u4ee5\u4e0a\u3067\u3059\u3002
\n\u6700\u5f8c\u307e\u3067\u304a\u8aad\u307f\u3044\u305f\u3060\u304d\u3042\u308a\u304c\u3068\u3046\u3054\u3056\u3044\u307e\u3057\u305f\u3002<\/p>\n
\u3010\u52d5\u4f5c\u691c\u8a3cDB\u3011
\nmySQL 8.0.39<\/p>\n","protected":false},"excerpt":{"rendered":"
\u3053\u306e\u8a18\u4e8b\u3067\u306fSQL\u3067\u306eSUM\u95a2\u6570\u306e\u4f7f\u3044\u65b9\u306b\u3064\u3044\u3066\u8d85\u521d\u5fc3\u8005\u5411\u3051\u306b\u5206\u304b\u308a\u3084\u3059\u304f\u89e3\u8aac\u3057\u307e\u3059\u3002 \u76ee\u6b211\uff0e SUM\u95a2\u6570\u3068\u306f\uff11-\uff11\uff0e SUM\u95a2\u6570\u3068\u306f\uff11-\uff12\uff0eSUM\u95a2\u6570\u306e\u69cb\u65872\uff0e SUM\u95a2\u6570\u306e\u30b5\u30f3\u30d7\u30eb\u30b3\u30fc\u30c9\uff12-\uff11\uff0e\u6570\u5024\u306e\u5408\u8a08\uff12-\uff12\uff0eN […]<\/p>\n","protected":false},"author":28,"featured_media":1181,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[17],"acf":[],"_links":{"self":[{"href":"https:\/\/www.bold.ne.jp\/engineer-club\/wp-json\/wp\/v2\/posts\/5872"}],"collection":[{"href":"https:\/\/www.bold.ne.jp\/engineer-club\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bold.ne.jp\/engineer-club\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bold.ne.jp\/engineer-club\/wp-json\/wp\/v2\/users\/28"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bold.ne.jp\/engineer-club\/wp-json\/wp\/v2\/comments?post=5872"}],"version-history":[{"count":8,"href":"https:\/\/www.bold.ne.jp\/engineer-club\/wp-json\/wp\/v2\/posts\/5872\/revisions"}],"predecessor-version":[{"id":5882,"href":"https:\/\/www.bold.ne.jp\/engineer-club\/wp-json\/wp\/v2\/posts\/5872\/revisions\/5882"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.bold.ne.jp\/engineer-club\/wp-json\/wp\/v2\/media\/1181"}],"wp:attachment":[{"href":"https:\/\/www.bold.ne.jp\/engineer-club\/wp-json\/wp\/v2\/media?parent=5872"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bold.ne.jp\/engineer-club\/wp-json\/wp\/v2\/categories?post=5872"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"\u30aa\u30fc\u30c8\u30b5\u30e0\"](\"https:\/\/www.bold.ne.jp\/engineer-club\/wp-content\/uploads\/2025\/10\/\u3042.jpg\")
<\/a><\/p>\n