{"id":756,"date":"2021-10-05T18:32:31","date_gmt":"2021-10-05T09:32:31","guid":{"rendered":"https:\/\/suzutukiblog.com\/?p=756"},"modified":"2022-01-19T01:09:59","modified_gmt":"2022-01-18T16:09:59","slug":"mysql8","status":"publish","type":"post","link":"https:\/\/suzutukiblog.com\/index.php\/2021\/10\/05\/mysql8\/","title":{"rendered":"MySQL(\u305d\u306e8 \u96c6\u7d04\u95a2\u6570(sum,avg,min,max))"},"content":{"rendered":"

\u305d\u306e\uff17\u304b\u3089\u3064\u3065\u304d\u307e\u3059\u3002<\/a><\/p>\n

1:\u96c6\u7d04\u95a2\u6570\u3068\u306f\uff1f<\/h3>\n

SQL\u3067\u30c6\u30fc\u30d6\u30eb\u306e\u5024\u3092\u96c6\u8a08\u3059\u308b\u305f\u3081\u306b\u4f7f\u3046\u3002<\/p>\n

\u95a2\u6570(function)\u3068\u306f\u3001\u69d8\u3005\u306a\u8a08\u7b97\u3092\u30d1\u30c3\u30b1\u30fc\u30b8\u5316\u3057\u305f\u3082\u306e<\/p>\n

2:\u5408\u8a08\u5024\u3092\u6c42\u3081\u308bsum\u96c6\u7d04\u95a2\u6570<\/h3>\n

\u4f8b\uff1a2017\u5e741\u6708\u306e\u5408\u8a08\u91d1\u984d\u3092\u8abf\u3079\u305f\u3044\uff01ER\u56f3<\/a>\u3088\u308aorders\u30c6\u30fc\u30d6\u30eb\u304b\u3089\u63a2\u3059<\/h3>\n

\"\"<\/p>\n

<\/p>\n

select<\/strong>\r\nsum(amount)<\/strong>\r\nfrom orders<\/strong>\r\nwhere order_time >= '2017-01-01 00:00:00'<\/strong>\r\nand order_time < '2017-02-01 00:00:00';<\/strong><\/pre>\n
\u203b\u30dd\u30a4\u30f3\u30c8<\/strong><\/p>\n
sum()\u306e\u4e2d\u306b\u5408\u8a08\u3057\u305f\u3044\u3082\u306e\u3092\u5165\u308c\u3066\u3001where order_time\u3067\u96c6\u8a08\u3057\u305f\u3044\u671f\u9593\u3092\u6307\u5b9a\u3059\u308b\u3002<\/p>\n
3:\u5e73\u5747\u5024\u3092\u6c42\u3081\u308bavg\u96c6\u7d04\u95a2\u6570<\/h3>\n
\u4f8b\uff1a\u81ea\u793eEC\u30b5\u30a4\u30c8(\u67b6\u7a7a)\u3067\u53d6\u308a\u6271\u3063\u3066\u3044\u308b\u5168\u5546\u54c1\u306e\u5e73\u5747\u4fa1\u683c\u3092\u8abf\u3079\u305f\u3044\uff01<\/h3>\n
\"\"<\/p>\n
select avg(price) from products;<\/strong><\/pre>\n
4:\u6700\u5c0f\u5024\u3092\u6c42\u3081\u308bmin\u96c6\u7d04\u95a2\u6570<\/h3>\n
\u4f8b\uff1a\u81ea\u793e EC\u30b5\u30a4\u30c8(\u67b6\u7a7a)\u3067\u53d6\u308a\u6271\u3063\u3066\u3044\u308b\u5546\u54c1\u4fa1\u683c\u306e\u6700\u5c0f\u5024\u3092\u8abf\u3079\u305f\u3044\uff01<\/h3>\n
\"\"<\/p>\n
select min(price) from products;<\/strong><\/pre>\n
5:\u6700\u5927\u5024\u3092\u6c42\u3081\u308bmax\u96c6\u7d04\u95a2\u6570<\/h3>\n
\u4f8b\uff1a\u81ea\u793e EC\u30b5\u30a4\u30c8(\u67b6\u7a7a)\u3067\u53d6\u308a\u6271\u3063\u3066\u3044\u308b\u5546\u54c1\u4fa1\u683c\u306e \u6700\u5927\u5024\u3092\u8abf\u3079\u305f\u3044\uff01<\/h3>\n
\"\"<\/p>\n
select max(price) from products;<\/strong><\/pre>\n
6:null\u306b\u3064\u3044\u3066<\/h3>\n
\u96c6\u7d04\u95a2\u6570\u3067\u306f\u3001\u57fa\u672c\u7684\u306b\u306fnull\u304c\u7121\u8996<\/strong>\u3055\u308c\u308b\u304c\u3001\u53ef\u80fd\u3067\u3042\u308c\u3070\u5217\u306bnull\u304c\u542b\u307e\u308c\u306a\u3044\u3088\u3046\u306b\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u69cb\u9020\u3092\u8a2d\u8a08\u3057\u305f\u307b\u3046\u304c\u30c8\u30e9\u30d6\u30eb\u304c\u6e1b\u308b\u3002<\/p>\n
\u6570\u5024\u306e0\u3084\u6587\u5b57\u5217\u306e””\u7a7a\u6587\u5b57\u306a\u3069\u3092\u4f7f\u3048\u308b\u3068\u304d\u306f\u4f7f\u3046<\/p>\n
\u305d\u306e\uff19\u306b\u7d9a\u304d\u307e\u3059\u3002<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
\u305d\u306e\uff17\u304b\u3089\u3064\u3065\u304d\u307e\u3059\u3002 1:\u96c6\u7d04\u95a2\u6570\u3068\u306f\uff1f SQL\u3067\u30c6\u30fc\u30d6\u30eb\u306e\u5024\u3092\u96c6\u8a08\u3059\u308b\u305f\u3081\u306b\u4f7f\u3046\u3002 \u95a2\u6570(function)\u3068\u306f\u3001\u69d8\u3005\u306a\u8a08\u7b97\u3092\u30d1\u30c3\u30b1\u30fc\u30b8\u5316\u3057\u305f\u3082\u306e 2:\u5408\u8a08\u5024\u3092\u6c42\u3081\u308bsum\u96c6\u7d04\u95a2\u6570 \u4f8b\uff1a2017\u5e741\u6708\u306e\u5408\u8a08\u91d1\u984d\u3092\u8abf\u3079 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[5,27],"tags":[],"class_list":["post-756","post","type-post","status-publish","format-standard","hentry","category-mysql","category-programming-note"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/suzutukiblog.com\/index.php\/wp-json\/wp\/v2\/posts\/756","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/suzutukiblog.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/suzutukiblog.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/suzutukiblog.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/suzutukiblog.com\/index.php\/wp-json\/wp\/v2\/comments?post=756"}],"version-history":[{"count":15,"href":"https:\/\/suzutukiblog.com\/index.php\/wp-json\/wp\/v2\/posts\/756\/revisions"}],"predecessor-version":[{"id":4361,"href":"https:\/\/suzutukiblog.com\/index.php\/wp-json\/wp\/v2\/posts\/756\/revisions\/4361"}],"wp:attachment":[{"href":"https:\/\/suzutukiblog.com\/index.php\/wp-json\/wp\/v2\/media?parent=756"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/suzutukiblog.com\/index.php\/wp-json\/wp\/v2\/categories?post=756"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/suzutukiblog.com\/index.php\/wp-json\/wp\/v2\/tags?post=756"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}