{"id":981,"date":"2021-01-25T01:47:23","date_gmt":"2021-01-24T16:47:23","guid":{"rendered":"https:\/\/skyit.biz\/?p=981"},"modified":"2021-01-25T01:47:24","modified_gmt":"2021-01-24T16:47:24","slug":"%e7%ac%ac8%e7%ab%a0%e5%89%af%e5%95%8f%e5%90%88%e3%81%9b%e3%81%ab%e3%82%88%e3%82%8b%e5%95%8f%e5%90%88%e3%81%9b%e3%81%ae%e8%a7%a3%e6%b1%ba%e6%96%b9%e6%b3%95","status":"publish","type":"post","link":"https:\/\/skyit.biz\/?p=981","title":{"rendered":"\u7b2c8\u7ae0\t\u526f\u554f\u5408\u305b\u306b\u3088\u308b\u554f\u5408\u305b\u306e\u89e3\u6c7a\u65b9\u6cd5"},"content":{"rendered":"\n

\u25a0\u4e3b\u554f\u5408\u305b\u3068\u7570\u306a\u308b\u8868\u3092\u554f\u5408\u305b\u308b\u526f\u554f\u5408\u305b<\/p>\n\n\n\n

\u25a0\u8907\u6570\u306e\u526f\u554f\u5408\u305b\u3092\u4f7f\u7528\u3059\u308b\u4e3b\u554f\u5408\u305b<\/p>\n\n\n\n

\u25a0\u526f\u554f\u5408\u305b\u306eWHERE\u53e5\u4ee5\u5916\u3067\u4f7f\u7528<\/p>\n\n\n\n

\u25a0FROM\u53e5\u3067\u306e\u526f\u554f\u5408\u305b\u306e\u4f7f\u7528
FROM\u53e5\u3067\u3001\u526f\u554f\u5408\u305b\u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u3002
FROM\u53e5\u3067\u3001\u526f\u554f\u5408\u305b\u3092\u4f7f\u7528\u3057\u3066\u3001\u305d\u306e\u4e2d\u3067\u3001GROUP BY\u53e5\u3082\u4f7f\u7528\u53ef\u80fd\u3067\u3042\u308b\u3002<\/p>\n\n\n\n

\u25a0IN\u6f14\u7b97\u5b50\u3092\u4f7f\u7528\u3057\u305f\u8907\u6570\u884c\u526f\u554f\u5408\u305b<\/p>\n\n\n\n

\u25a0ANY\u6f14\u7b97\u5b50\u3092\u4f7f\u7528\u3057\u305f\u8907\u6570\u884c\u526f\u554f\u5408\u305b
=ANY\u3068IN\u306f\u540c\u3058\u610f\u5473\u3068\u306a\u308b\u3002<\/p>\n\n\n\n

ANY \u30ea\u30b9\u30c8\u5185\u306e\u5024\u306e\u3044\u305a\u308c\u304b\u3088\u308a\u3082\u5927\u304d\u3051\u308c\u3070\u3001TRUE\u3092\u623b\u3059\u306e\u3067\u3001\u30ea\u30b9\u30c8\u5185\u306e\u6700\u5c0f\u5024\u3088\u308a\u3082\u5927\u304d\u3044\u5834\u5408\u3068\u3044\u3046\u610f\u5473\u306b\u306a\u308b\u3002
\u6bd4\u8f03\u5bfe\u8c61\u306e\u5217\u306e\u5024\u304c\u30ea\u30b9\u30c8\u5185\u306e\u6700\u5c0f\u5024\u3088\u308a\u3082\u5927\u304d\u3044\u5834\u5408\u306bTRUE\u3092\u623b\u3059\u3002
<ANY \u6bd4\u8f03\u5bfe\u8c61\u306e\u5217\u306e\u5024\u304c\u30ea\u30b9\u30c8\u5185\u306e\u6700\u5927\u5024\u3088\u308a\u3082\u5c0f\u3055\u3044\u5834\u5408\u306bTRUE\u3092\u623b\u3059\u3002<\/p><\/blockquote>\n\n\n\n

\u25a0ALL\u6f14\u7b97\u5b50\u3092\u4f7f\u7528\u3057\u305f\u8907\u6570\u884c\u526f\u554f\u5408\u305b<\/p>\n\n\n\n

ALL \u6bd4\u8f03\u5bfe\u8c61\u306e\u5217\u306e\u5024\u304c\u3001\u30ea\u30b9\u30c8\u5185\u306e\u6700\u5927\u5024\u3088\u308a\u3082\u5927\u304d\u3044\u5834\u5408\u306bTRUE\u3092\u623b\u3059
<ALL \u6bd4\u8f03\u5bfe\u8c61\u306e\u5217\u306e\u5024\u304c\u3001\u30ea\u30b9\u30c8\u5185\u306e\u6700\u5c0f\u5024\u3088\u308a\u3082\u5c0f\u3055\u3044\u5834\u5408\u306bTRUE\u3092\u623b\u3059<\/p><\/blockquote>\n\n\n\n

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

\"\"<\/figure>\n\n\n\n

<>ALL\u306f\u3001NOT IN\u3068\u540c\u3058\u3002
ANY\u306e\u5426\u5b9a\u306f\u3001ALL
ALL\u306e\u5426\u5b9a\u306f\u3001ANY<\/p>\n\n\n\n

\u526f\u554f\u5408\u305b\u306b\u304a\u3051\u308bIN\u6f14\u7b97\u5b50\u3068NULL\u5024<\/p>\n\n\n\n

NOT IN(\u5024\u306e\u30ea\u30b9\u30c8)
<>ALL(\u5024\u306e\u30ea\u30b9\u30c8)<\/p>\n\n\n\n

NOT\u6f14\u7b97\u5b50\u306f\u3001IN\u3001ANY\u3001ALL\u6f14\u7b97\u5b50\u3068\u4e00\u7dd2\u306b\u4f7f\u7528\u3067\u304d\u308b\u3002<\/p>\n\n\n\n

SELECT\u6587\u3068SELECT\u53e5\u306f\u5225\u7269\u306a\u306e\u3067\u3001\u8981\u78ba\u8a8d\u3059\u308b\u3053\u3068\u3002<\/p>\n\n\n\n

\u526f\u554f\u5408\u305b\u306f\u3001SQL\u6587\u306e\u3044\u304f\u3064\u304b\u306e\u53e5\u306e\u4e2d\u3067\u4f7f\u3046\u3053\u3068\u304c\u3067\u304d\u308b\u3002
SELECT\u6587\u306e\u4e2d\u3067\u306f\u3001WHERE\u53e5\u3001FROM\u53e5\u3001HAVING\u53e5\u3067\u526f\u554f\u5408\u305b\u3092\u4f7f\u3046\u3053\u3068\u304c\u3067\u304d\u308b\u3002
\u526f\u554f\u5408\u305b\u304c\u6700\u521d\u306b\u5b9f\u884c\u3055\u308c\u3001\u6b21\u306b\u305d\u306e\u7d50\u679c\u3092\u4f7f\u3063\u3066\u4e3b\u554f\u5408\u305b\u304c\u5b9f\u884c\u3055\u308c\u308b\u3002<\/p>\n\n\n\n

\u25bc\u526f\u554f\u5408\u305b\u306e\u4ed5\u69d8\u306b\u95a2\u3059\u308b\u30ac\u30a4\u30c9\u30e9\u30a4\u30f3
\u526f\u554f\u5408\u305b\u306f\u3001\u30ac\u30c3\u30b3\u3067\u56f2\u3080
\u526f\u554f\u5408\u305b\u306f\u3001\u8aad\u307f\u3084\u3059\u3044\u3088\u3046\u306b\u6bd4\u8f03\u6f14\u7b97\u5b50\u306e\u610f\u7fa9\u5074\u306b\u7f6e\u304f\uff08\u5de6\u5074\u306b\u7f6e\u304f\u3053\u3068\u3082\u3067\u304d\u308b\uff09
\u526f\u554f\u5408\u305b\u3067\u306f\u3001\u5358\u4e00\u884c\u6bd4\u8f03\u6f14\u7b97\u5b50\u3068\u8907\u6570\u884c\u6bd4\u8f03\u6f14\u7b97\u5b50\u306e2\u7a2e\u985e\u306e\u6bd4\u8f03\u6f14\u7b97\u5b50\u3092\u4f7f\u7528\u3067\u304d\u308b\u3002<\/p>\n\n\n\n

\u25a0EXISTS\u6f14\u7b97\u5b50
EXISTS\u6f14\u7b97\u5b50\u306f\u3001\u8868\u306b\u7279\u5b9a\u306e\u884c\u304c\u5b58\u5728\u3059\u308b\u304b\u5426\u304b\u306b\u3088\u3063\u3066\u3001\u554f\u3044\u5408\u308f\u305b\u306e\u7d50\u679c\u304c\u5909\u5316\u3059\u308b\u554f\u5408\u305b\uff08\u5b58\u5728\u30c1\u30a7\u30c3\u30af\uff09\u3067\u4f7f\u7528\u3059\u308b\u3002
EXISTS\u6f14\u7b97\u5b50\u3092\u6307\u5b9a\u3059\u308b\u3068\u3001\u4e3b\u554f\u5408\u305b\u306e\u5404\u884c\u306b\u5bfe\u3057\u3066\u30011\u56de\u305a\u3064\u526f\u554f\u5408\u305b\u304c\u5b9f\u884c\u3055\u308c\u308b\u306e\u3067\u3001\u6761\u4ef6\u306b\u5408\u3046\u884c\u304c\u5b58\u5728\u3059\u308b\u304b\u5426\u304b\u3092\u30c1\u30a7\u30c3\u30af\u3067\u304d\u308b\u3002<\/p>\n\n\n\n

IN\u6f14\u7b97\u5b50\u306b\u7f6e\u304d\u63db\u3048\u304c\u3067\u304d\u308b\u3002<\/p>\n\n\n\n

NOT EXISTS\u6f14\u7b97\u5b50\u306f\u3001\u5f8c\u7d9a\u306e\u526f\u554f\u5408\u305b\u304b\u3089\u30c7\u30fc\u30bf\u304c1\u4ef6\u3082\u623b\u3055\u308c\u306a\u3044\u5834\u5408\u306b\u3001TRUE\u3092\u623b\u3057\u30011\u4ef6\u4ee5\u4e0a\u623b\u3055\u308c\u305f\u5834\u5408\u306fFALSE\u3092\u623b\u3059\u3002
EXISTS\u6f14\u7b97\u5b50\u306f\u3001\u5f8c\u7d9a\u306e\u526f\u554f\u5408\u305b\u304b\u3089\u30c7\u30fc\u30bf\u304c1\u4ef6\u4ee5\u4e0a\u623b\u3055\u308c\u305f\u5834\u5408\u306b\u3001TRUE\u3092\u623b\u3057\u30011\u770c\u3082\u623b\u3055\u308c\u306a\u3044\u5834\u5408\u306fFALSE\u3092\u623b\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

\u25a0\u4e3b\u554f\u5408\u305b\u3068\u7570\u306a\u308b\u8868\u3092\u554f\u5408\u305b\u308b\u526f\u554f\u5408\u305b \u25a0\u8907\u6570\u306e\u526f\u554f\u5408\u305b\u3092\u4f7f\u7528\u3059\u308b\u4e3b\u554f\u5408\u305b \u25a0\u526f\u554f\u5408\u305b\u306eWHERE\u53e5\u4ee5\u5916\u3067\u4f7f\u7528 \u25a0FROM\u53e5\u3067\u306e\u526f\u554f\u5408\u305b\u306e\u4f7f\u7528FROM\u53e5\u3067\u3001\u526f\u554f\u5408\u305b\u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u3002FROM\u53e5\u3067\u3001\u526f\u554f\u5408\u305b\u3092\u4f7f\u7528\u3057\u3066 […]<\/p>\n","protected":false},"author":1,"featured_media":982,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[38,52,12],"tags":[],"class_list":{"0":"post-981","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-bronze-dba-12c","8":"category-bronze-sql-12c","9":"category-oracle"},"_links":{"self":[{"href":"https:\/\/skyit.biz\/index.php?rest_route=\/wp\/v2\/posts\/981","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/skyit.biz\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/skyit.biz\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/skyit.biz\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/skyit.biz\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=981"}],"version-history":[{"count":1,"href":"https:\/\/skyit.biz\/index.php?rest_route=\/wp\/v2\/posts\/981\/revisions"}],"predecessor-version":[{"id":983,"href":"https:\/\/skyit.biz\/index.php?rest_route=\/wp\/v2\/posts\/981\/revisions\/983"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/skyit.biz\/index.php?rest_route=\/wp\/v2\/media\/982"}],"wp:attachment":[{"href":"https:\/\/skyit.biz\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=981"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/skyit.biz\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=981"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/skyit.biz\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=981"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}