{"url":"https://tigertaizo.hatenablog.com/entry/2025/08/08/213000","width":"100%","provider_name":"Hatena Blog","author_name":"no14141","published":"2025-08-08 21:30:00","image_url":null,"description":"\u76f8\u95a2\u30b5\u30d6\u30af\u30a8\u30ea\u3092\u4f7f\u3063\u305fSQL \u3053\u308c\u307e\u3067\u3001\u76f8\u95a2\u30b5\u30d6\u30af\u30a8\u30ea\u3092\u4f7f\u3044\u307e\u304f\u3063\u3066\u304d\u307e\u3057\u305f\u3002 \u76f8\u95a2\u30b5\u30d6\u30af\u30a8\u30ea\u3068\u306f\u3001\u89aa\u306e\u884c\u3092\u898b\u306a\u304c\u3089\u3001\u6bce\u56de\u8d70\u308b\u30af\u30a8\u30ea\u3067\u3001\u89aa\u30c6\u30fc\u30d6\u30eb\u306e\u5217\u3092\u300cWHERE\u53e5\u300d\u3084\u300cSELECT\u9805\u76ee\u300d\u3067\u53c2\u7167\u3059\u308b\u66f8\u304d\u65b9\u3002 \u89aa\u306e1\u884c\u53d6\u5f97 \u2192 \u5b50\u30b5\u30d6\u30af\u30a8\u30ea\u5b9f\u884c \u2192 \u7d50\u679c\u3092\u8fd4\u3059\u2026 \u3092\u884c\u6570\u5206\u7e70\u308a\u8fd4\u3059\u305f\u3081\u3001\u884c\u6570\u306b\u6bd4\u4f8b\u3057\u3066\u91cd\u304f\u306a\u3063\u3066\u3057\u307e\u3044\u307e\u3059\u3002 \u4f8b\u3068\u3057\u3066\u306f\u3001\u3053\u3093\u306a\u611f\u3058\u3067\u3059\u3002 -- \u89aa\u884c\u306b\u6700\u65b0\u6ce8\u6587\u65e5\u3092\u6dfb\u3048\u308b SELECT c.customer_id, c.customer_name, (SELECT MAX(o.order_date) FROM orders o WHERE o.customer_id = c.cust\u2026","provider_url":"https://hatena.blog","blog_url":"https://tigertaizo.hatenablog.com/","title":"\u3010SQL\u3011\u76f8\u95a2\u30b5\u30d6\u30af\u30a8\u30ea\u306e\u4ee3\u308f\u308a\u306bLATERAL\u53e5\u3092\u8a66\u3057\u3066\u307f\u305f","author_url":"https://blog.hatena.ne.jp/no14141/","version":"1.0","type":"rich","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Ftigertaizo.hatenablog.com%2Fentry%2F2025%2F08%2F08%2F213000\" title=\"\u3010SQL\u3011\u76f8\u95a2\u30b5\u30d6\u30af\u30a8\u30ea\u306e\u4ee3\u308f\u308a\u306bLATERAL\u53e5\u3092\u8a66\u3057\u3066\u307f\u305f - \u30bf\u30a4\u30ac\u30fc\uff01\u30bf\u30a4\u30ac\u30fc\uff01\u3058\u308c\u3063\u305f\u3044\u305e\u30fc\uff01\uff08SE\u7de8\uff09\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","blog_title":"\u30bf\u30a4\u30ac\u30fc\uff01\u30bf\u30a4\u30ac\u30fc\uff01\u3058\u308c\u3063\u305f\u3044\u305e\u30fc\uff01\uff08SE\u7de8\uff09","height":"190","categories":["DB2/400","PostgreSQL","SQL"]}