{"id":1748,"date":"2013-06-18T06:30:42","date_gmt":"2013-06-17T21:30:42","guid":{"rendered":"http:\/\/fry.no.coocan.jp\/WordPress\/?p=1748"},"modified":"2013-06-18T06:53:44","modified_gmt":"2013-06-17T21:53:44","slug":"%e3%83%87%e3%83%bc%e3%82%bf%e3%83%99%e3%83%bc%e3%82%b9%e6%a4%9c%e7%b4%a2","status":"publish","type":"post","link":"http:\/\/fry.no.coocan.jp\/WordPress\/?p=1748","title":{"rendered":"\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u691c\u7d22"},"content":{"rendered":"

\uff08\u4ee5\u4e0b\u306e\u8868\u306f\u3001\u7686\u69d8\u306e\u30b5\u30a4\u30c8\u3067\u306f\u30ba\u30ec\u3066\u8868\u793a\u3055\u308c\u3066\u3044\u308b\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u3002\u3059\u307f\u307e\u305b\u3093\u3001\u6280\u304c\u306a\u304f\u3066\u3001\u8868\u793a\u3092\u305d\u308d\u3048\u3089\u308c\u307e\u305b\u3093\u3002\u3067\u304d\u308c\u3070\u3001\u8fd1\u3044\u5185\u306b\u76f4\u3057\u307e\u3059\uff09
\n\u4eca\u65e5\u306f\u3001\u660e\u65e5\u6388\u696d\u3067\u4f7f\u3046\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3078\u306e\u8cea\u554f\uff08SQL\uff09\u306e\u4f8b\u3067\u3059\u3002<\/p>\n

\u90e8\u5916\u8005\u306e\u65b9\u306f\u3001\u300cEXCEL\u8868\u3078\u306e\u8cea\u554f\u300d\u3060\u3068\u601d\u3063\u3066\u4e0b\u3055\u3044\u3002<\/p>\n

\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3078\u306e\u8cea\u554f\u300cSELECT WHERE\u300d\u547d\u4ee4\u306e\u69cb\u6587\u306f\u6b21\u306e\u3068\u304a\u308a\u3067\u3059\u3002<\/p>\n

SELECT a FROM b WHERE c
\n\u548c\u8a33\u306f\uff1a\u3000b\u3068\u3044\u3046\u8868\u304b\u3089\u3001c\u3068\u3044\u3046\u6761\u4ef6\u3092\u6e80\u305f\u3059\u884c\uff08\u6a2a\uff09\u3092\u63a2\u3057\u3001\u305d\u306ea\u5217\u3092\u8868\u793a\u3057\u306a\u3055\u3044\u3001\u3067\u3059\u3002<\/p>\n

\u4f8b\uff11\uff1a\u672c\u306e\u8868\u306e\u5834\u5408<\/p>\n

“book_list”
\n+———–+——-+—————+——–+————-+
\n| book_id | title\u00a0\u00a0 | author\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0| price |\u00a0 comment |
\n+———-+——–+————–+———+————-|
\n|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 |\u00a0\u00a0\u00a0\u00a0 A\u00a0 \u00a0| OOE\u00a0\u00a0\u00a0 \u00a0\u00a0 \u00a0 |\u00a0 1700 | funny\u00a0\u00a0\u00a0 \u00a0\u00a0 |
\n|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a02 |\u00a0\u00a0\u00a0\u00a0 B\u00a0 \u00a0| MISIMA\u00a0\u00a0 \u00a0|\u00a0 2000 | sad\u00a0 \u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0 |
\n|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 3 |\u00a0\u00a0\u00a0\u00a0 C\u00a0\u00a0 |\u00a0NATUME |\u00a0 1400 | happy \u00a0\u00a0\u00a0 \u00a0|
\n|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0 4 |\u00a0\u00a0\u00a0\u00a0 D\u00a0\u00a0 |\u00a0MORI\u00a0\u00a0\u00a0 \u00a0\u00a0 |\u00a0\u00a0 \u00a0700 | serious\u00a0\u00a0 \u00a0|
\n|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 5 |\u00a0\u00a0\u00a0\u00a0 E\u00a0\u00a0 |\u00a0DAZAI\u00a0\u00a0\u00a0 \u00a0\u00a0|\u00a0 1000 | sad\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 \u00a0|
\n|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 \u00a0 6 |\u00a0\u00a0\u00a0\u00a0 F\u00a0\u00a0 | NATUME \u00a0|\u00a0 2400 | love\u00a0\u00a0\u00a0 \u00a0 \u00a0\u00a0 |
\n+———-+——–+————-+———+————-+<\/p>\n

\u8cea\u554f\u4f8b\uff11<\/p>\n

SELECT * FROM book_list WHERE price < 1500<\/p>\n

\u548c\u8a33\uff1abook_list\u3068\u3044\u3046\u8868\u3067\u3001price\u304c1500\u5186\u4ee5\u4e0b\u306e\u672c\u306e\u5168\u3066\u306e\u5217\u3092\u8868\u793a\u3057\u306a\u3055\u3044\u3002
\n\u7d50\u679c\u306f\u3001\u6b21\u306e\u3068\u304a\u308a\u3067\u3059\u3002<\/p>\n

+———–+——+————-+——-+————-+
\n| book_id | \u00a0title |\u00a0\u00a0\u00a0\u00a0\u00a0 author | price | comment |
\n+———-+——-+————-+——-+————–|
\n|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3 |\u00a0\u00a0\u00a0\u00a0 C | NATUME |\u00a0 1400 | happy\u00a0 \u00a0\u00a0 |
\n|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4 |\u00a0\u00a0\u00a0\u00a0 D | MORI\u00a0\u00a0\u00a0\u00a0 \u00a0 |\u00a0\u00a0 700 | serious\u00a0\u00a0 \u00a0|
\n|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u30005 |\u00a0\u00a0\u00a0\u00a0 E | DAZAI\u00a0\u00a0\u00a0\u00a0 |\u00a0 1000 | sad\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0 \u00a0|
\n+———-+——-+————+———+————-+<\/p>\n

\uff08\u547d\u4ee4\u306e * \u306f\u3001\u5168\u3066\u306e\u5217\u3092\u8868\u793a\u305b\u3088\u3068\u3044\u3046\u610f\u5473\u3067\u3059\uff09<\/p>\n

\u8cea\u554f\u4f8b\uff12<\/p>\n

SELECT title,price FROM book_list WHERE author=’NATUME’
\n\u548c\u8a33\uff1abook_list\u3068\u3044\u3046\u8868\u3067\u3001\u8457\u8005\u304c\u590f\u76ee\u306e\u672c\u306e\u66f8\u540d\u3068\u5024\u6bb5\u3092\u8868\u793a\u3057\u307e\u3055\u3044\u3002
\n\u7d50\u679c\uff1a
\n+——-+——-+
\n| title\u00a0\u00a0 \u00a0| price |
\n+——-+——-+
\n|\u00a0\u00a0\u00a0\u00a0 C \u00a0|\u00a0 1400 |
\n|\u00a0\u00a0\u00a0\u00a0 F\u00a0 |\u00a0 2400 |
\n+——-+——-+<\/p>\n

\uff1d\uff1d\uff1d\uff1d\uff1d\uff1d\uff1d\uff1d\uff1d<\/p>\n

SQL\u3067\u306f\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u5bfe\u3057\u3066\u3001\u8868\u306e\u8a08\u7b97\u7d50\u679c\u3092\u6c42\u3081\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002
\n\u4f8b\uff12\u3000\uff1a\u5e73\u5747\uff08average\uff09\u3092\u6c42\u3081\u308b\u4f8b<\/p>\n

“score_table”<\/p>\n

+—–+————–+——-+
\n| No\u00a0 | subject\u00a0\u00a0 \u00a0 | score |
\n+—–+————-+——–+
\n| A01 | Science\u00a0 |\u3000 60\u00a0\u00a0 |
\n| A01 | Math\u00a0\u00a0\u00a0\u00a0 \u00a0 | \u300050\u00a0\u00a0 |
\n| A01 | English\u00a0\u00a0 |\u3000 40\u00a0\u00a0 |
\n| A02 | Science\u00a0 |\u3000 40\u00a0\u00a0 |
\n| A02 | Math\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0|\u3000 70\u00a0\u00a0 |
\n| A02 | English\u00a0 \u00a0|\u3000 30\u00a0\u00a0 |
\n+—–+————-+——-+<\/p>\n

\u8cea\u554f\u4f8b\uff11<\/p>\n

\u5b66\u7c4d\u756a\u53f7\uff08No\uff09\u304cA01\u306e\u4eba\u306e\u5e73\u5747\u70b9\u3092\u6c42\u3081\u308b\u5834\u5408\u306eSQL\u6587\u306f\u6b21\u306e\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n

SELECT AVG(score) AS AVERAGE FROM score_table WHERE No = ‘A01’<\/p>\n

\u548c\u8a33\uff1ascore_table \u306e\u5b66\u7c4d\u756a\u53f7 = ‘A01’\u306e\u4eba\u306e\u300cscore\u300d\u5217\u306e\u5e73\u5747\u3092\u3068\u308a\u3001AVG(score)\u3092\u300cAVERAGE\u300d\u3068\u66f8\u304d\u76f4\u3057\u3066\u8868\u793a\u3057\u306a\u3055\u3044\u3002<\/p>\n

\u7d50\u679c\u306f\u4e0b\u8a18\u306e\u3068\u304a\u308a\u3067\u3059\u3002<\/p>\n

+—————+
\n| AVERAGE |
\n+————–+
\n|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 50\u00a0\u00a0\u00a0 |
\n+————–+<\/p>\n

\uff08AS\u306f\u3001\u5225\u306e\u540d\u306b\u66f8\u304d\u63db\u3048\u306a\u3055\u3044\u3001\u3068\u3044\u3046\u610f\u5473\u3067\u3059\u3002\u4e0a\u306e\u4f8b\u3067\u306f\u3001AS\u6307\u5b9a\u3057\u306a\u3044\u3068\u5217\u540d\u304c\u300cAVG(score)\u300d\u3068\u306a\u308a\u307e\u3059\uff09<\/p>\n

\u8cea\u554f\u4f8b\uff12 \u8868\u306e\u4e2d\u8eab\u3092\uff08GROUP BY\u3000\u3067\uff09\u30b0\u30eb\u30fc\u30d7\u5316\u3057\u3066\u8a08\u7b97\u51e6\u7406\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002<\/p>\n

GROUP BY\u3000\u306e\u69cb\u6587\u306f\u6b21\u306e\u3068\u304a\u308a\u3067\u3059\u3002 SELECT \u5217\u540d\u30fb\u30fb\u30fb FROM \u8868\u540d GROUP BY \u5217\u540d;<\/p>\n

\u5177\u4f53\u4f8b
\nSELECT No,SUM(score) FROM score_table GROUP BY No;<\/p>\n

\u548c\u8a33\uff1a\u5b66\u751f\u3054\u3068\u306b\u5408\u8a08\u70b9\u3092\u6c42\u3081No\u3068SUM(score)\u3068\u3044\u3046\u5217\u3092\u8868\u793a\u3057\u306a\u3055\u3044\u3002<\/p>\n

+—–+—————-+
\n| No\u00a0 | SUM(score) |
\n+—–+—————–+
\n| A01 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 150\u00a0\u00a0\u00a0 |
\n| A02 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0140\u00a0\u00a0\u00a0 |
\n+—–+—————–+<\/p>\n

\uff1d\uff1d\uff1d\uff1d\uff1d\uff1d\uff1d\uff1d\uff1d<\/p>\n

SQL\u3067\u306f\u3001WHERE\u3000\u306e\u4e2d\u3067\u3000LIKE \u3092\u4f7f\u3063\u3066\u5e45\u306e\u3042\u308b\u8868\u73fe\u3092\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n

\u6700\u521d\u306e\u4f8b\u306e\u300c\u672c\u306e\u30ea\u30b9\u30c8\u300d\u8868\u3067\u3001comment\u304cs\u3067\u59cb\u307e\u308b\u3082\u306e\u3092\u63a2\u3059\u306b\u306f\u6b21\u306e\u69d8\u306b\u6307\u5b9a\u3057\u307e\u3059\u3002
\nSELECT * FROM book_list\u00a0 WHERE comment LIKE ‘s%’
\n\uff08%\u306f\u3001\u30ef\u30a4\u30eb\u30c9\u30ab\u30fc\u30c9\u3068\u3044\u3046\u3053\u3068\u3067\u3059\u306d\uff09<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

\uff08\u4ee5\u4e0b\u306e\u8868\u306f\u3001\u7686\u69d8\u306e\u30b5\u30a4\u30c8\u3067\u306f\u30ba\u30ec\u3066\u8868\u793a\u3055\u308c\u3066\u3044\u308b\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u3002\u3059\u307f\u307e\u305b\u3093\u3001\u6280\u304c\u306a\u304f\u3066\u3001\u8868\u793a\u3092\u305d\u308d\u3048\u3089\u308c\u307e\u305b\u3093\u3002\u3067\u304d\u308c\u3070\u3001\u8fd1\u3044\u5185\u306b\u76f4\u3057\u307e\u3059\uff09 \u4eca\u65e5\u306f\u3001\u660e\u65e5\u6388\u696d\u3067\u4f7f\u3046\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3078\u306e\u8cea\u554f\uff08SQL\uff09\u306e\u4f8b\u3067\u3059\u3002 \u90e8\u5916\u8005\u306e\u65b9\u306f … \u7d9a\u304d\u3092\u8aad\u3080 →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"http:\/\/fry.no.coocan.jp\/WordPress\/index.php?rest_route=\/wp\/v2\/posts\/1748"}],"collection":[{"href":"http:\/\/fry.no.coocan.jp\/WordPress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/fry.no.coocan.jp\/WordPress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/fry.no.coocan.jp\/WordPress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/fry.no.coocan.jp\/WordPress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1748"}],"version-history":[{"count":11,"href":"http:\/\/fry.no.coocan.jp\/WordPress\/index.php?rest_route=\/wp\/v2\/posts\/1748\/revisions"}],"predecessor-version":[{"id":1755,"href":"http:\/\/fry.no.coocan.jp\/WordPress\/index.php?rest_route=\/wp\/v2\/posts\/1748\/revisions\/1755"}],"wp:attachment":[{"href":"http:\/\/fry.no.coocan.jp\/WordPress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1748"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/fry.no.coocan.jp\/WordPress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1748"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/fry.no.coocan.jp\/WordPress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1748"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}