{"id":22411,"date":"2023-04-17T10:48:17","date_gmt":"2023-04-17T01:48:17","guid":{"rendered":"http:\/\/nori.company\/?p=22411"},"modified":"2023-04-17T10:48:17","modified_gmt":"2023-04-17T01:48:17","slug":"sql2023%ec%97%90-%ec%83%88%eb%a1%9c-%ec%b6%94%ea%b0%80%eb%90%98%eb%8a%94-%ea%b2%83%eb%93%a4","status":"publish","type":"post","link":"https:\/\/nori.company\/?p=22411","title":{"rendered":"SQL:2023\uc5d0 \uc0c8\ub85c \ucd94\uac00\ub418\ub294 \uac83\ub4e4"},"content":{"rendered":"<ul>\n<li>\uc6cc\ud0b9\uadf8\ub8f9\uc774 \ucd5c\uc885\ubcf8\uc744 ISO\uc5d0 \uc804\ub2ec\ud588\uace0, \uc2b9\uc778 \ub300\uae30\uc911<\/li>\n<\/ul>\n<h2>\uae30\uc874 SQL \uc5b8\uc5b4\uc758 \ubcc0\uacbd<\/h2>\n<ul>\n<li>UNIQUE \uc758 NULL \ucc98\ub9ac \uba85\uc2dc<\/li>\n<li>GROUP\ub41c \ud14c\uc774\ube14\uc5d0\uc11c SELECT \ud558\uc9c0 \uc54a\uc740 \ud544\ub4dc\ub85c ORDER BY \uac00\ub2a5<\/li>\n<li>GREATEST, LEAST \ud568\uc218 \ucd94\uac00<\/li>\n<li>LPAD, RPAD \ud568\uc218 \ucd94\uac00<\/li>\n<li>\uba40\ud2f0 \uce90\ub9ad\ud130 TRIM \ud568\uc218\ub4e4(L&#8230;\n<p>\ucd9c\ucc98 : <a href=\"https:\/\/news.hada.io\/topic?id=8973\" target=\"_blank\" rel=\"noopener\">GeekNews &#8211; \uac1c\ubc1c\/\uae30\uc220\/\uc2a4\ud0c0\ud2b8\uc5c5 \ub274\uc2a4 \uc11c\ube44\uc2a4 <\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\uc6cc\ud0b9\uadf8\ub8f9\uc774 \ucd5c\uc885\ubcf8\uc744 ISO\uc5d0 \uc804\ub2ec\ud588\uace0, \uc2b9\uc778 \ub300\uae30\uc911 \uae30\uc874 SQL \uc5b8\uc5b4\uc758 \ubcc0\uacbd UNIQUE \uc758 NULL \ucc98\ub9ac \uba85\uc2dc GROUP\ub41c \ud14c\uc774\ube14\uc5d0\uc11c SELECT \ud558\uc9c0 \uc54a\uc740&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[138],"tags":[163],"class_list":["post-22411","post","type-post","status-publish","format-standard","hentry","category-it","tag-geeknews-----"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pa3PO4-5Pt","jetpack-related-posts":[{"id":24030,"url":"https:\/\/nori.company\/?p=24030","url_meta":{"origin":22411,"position":0},"title":"OpenAI \ud568\uc218 \ud638\ucd9c \uae30\ub2a5 \ucd94\uac00 GPT \ubaa8\ub378\ub4e4 \uc5c5\ub370\uc774\ud2b8 \ubc0f \uac00\uaca9 \uc778\ud558","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 6\uc6d4 14\uc77c","format":false,"excerpt":"\ud568\uc218 \ud638\ucd9c \uae30\ub2a5 \ucd94\uac00 \uac1c\ubc1c\uc790\uac00 \ud568\uc218\ub97c \uc120\uc5b8\ud558\uba74, gpt\uac00 \uc0ac\uc6a9\uc790 \uc785\ub825\uc5d0 \ub530\ub77c \uc5b4\ub5a4 \ud568\uc218\uac00 \ud638\ucd9c\ub418\uc5b4\uc57c \ud560\uc9c0 \uc778\uc2dd\ud55c \ud6c4 \ud638\ucd9c\ud558\uace0, JSON\uc73c\ub85c \uacb0\uacfc\ub97c \ub9ac\ud134 \ubaa8\ub378 \uc5c5\ub370\uc774\ud2b8 gpt-4-0613, gpt-4-32k-01613 \uc73c\ub85c \uc5c5\ub370\uc774\ud2b8 \ubc0f \ud568\uc218 \ud638\ucd9c \uae30\ub2a5 \ucd94\uac00 gpt-3.5-turbo-0613 \uc5c5... \ucd9c\ucc98 : GeekNews - \uac1c\ubc1c\/\uae30\uc220\/\uc2a4\ud0c0\ud2b8\uc5c5 \ub274\uc2a4 \uc11c\ube44\uc2a4","rel":"","context":"&quot;IT&quot;\uc5d0\uc11c","block_context":{"text":"IT","link":"https:\/\/nori.company\/?cat=138"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":24302,"url":"https:\/\/nori.company\/?p=24302","url_meta":{"origin":22411,"position":1},"title":"Go 1.21 Release Candidate \ucd9c\uc2dc","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 6\uc6d4 22\uc77c","format":false,"excerpt":"\ucef4\ud30c\uc77c \uc131\ub2a5 2~4% \uac1c\uc120 GC tail latency \ucd5c\ub300 40% \uac10\uc18c WASI \ud50c\ub7ab\ud3fc \uc9c0\uc6d0 \ucd94\uac00 \ud234\uccb4\uc778 forwards compatibility \uac1c\uc120 Execution Tracer Overhaul \ub0b4\uc7a5 \ud568\uc218 min, max, clear \ucd94\uac00 \uc81c\ub108\ub9ad \ud0c0\uc785 \ucd94\ub860 \uac1c\uc120 go:wasmimport \uc9c0\uc2dc\uc790 \ucd94\uac00 sl... \ucd9c\ucc98 : GeekNews - \uac1c\ubc1c\/\uae30\uc220\/\uc2a4\ud0c0\ud2b8\uc5c5 \ub274\uc2a4 \uc11c\ube44\uc2a4","rel":"","context":"&quot;IT&quot;\uc5d0\uc11c","block_context":{"text":"IT","link":"https:\/\/nori.company\/?cat=138"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":25591,"url":"https:\/\/nori.company\/?p=25591","url_meta":{"origin":22411,"position":2},"title":"llama2.c for Dummies (\ucd08\ubcf4\uc790\ub97c \uc704\ud55c llama2.c \uac00\uc774\ub4dc)","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 7\uc6d4 31\uc77c","format":false,"excerpt":"Andrej Karpathy\uac00 \uc791\uc131\ud55c, \uc21c\uc218 C\ub85c \uc791\uc131\ub41c Llama 2 \ucd94\ub860 \ucf54\ub4dc\uc778 llama2.c\uc5d0 \ub300\ud55c \uc124\uba85 \uc790\ub8cc\ud615(structs), \uac01\uc885 \ud568\uc218\uc640 \ub85c\uc9c1 \uc124\uba85, main() \ud568\uc218 \uc124\uba85\uc758 3\ubd80\ub85c \uad6c\uc131\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. \ucd9c\ucc98 : GeekNews - \uac1c\ubc1c\/\uae30\uc220\/\uc2a4\ud0c0\ud2b8\uc5c5 \ub274\uc2a4 \uc11c\ube44\uc2a4","rel":"","context":"&quot;IT&quot;\uc5d0\uc11c","block_context":{"text":"IT","link":"https:\/\/nori.company\/?cat=138"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":27522,"url":"https:\/\/nori.company\/?p=27522","url_meta":{"origin":22411,"position":3},"title":"\ucda9\ubd84\ud788 \ubc1c\ub2ec\ud55c Uninstaller\ub294 Malware\uc640 \uad6c\ubcc4\ud560 \uc218 \uc5c6\ub2e4","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 9\uc6d4 14\uc77c","format":false,"excerpt":"\ud0d0\uc0c9\uae30\uc758 \ud06c\ub798\uc26c\uac00 \uae09\uc99d\ud574\uc11c \uc774\uc720\ub97c \ucc3e\ub2e4\ubcf4\ub2c8 \uc2a4\ud0dd\uc5d0\uc11c \uc545\uc131\ucf54\ub4dc\uc640 \ube44\uc2b7\ud55c \ud568\uc218 \ud3ec\uc778\ud130\ub97c \ubc1c\uacac \ub4a4\uc838\ubcf4\ub2c8 \uc545\uc131\ucf54\ub4dc\uac00 \uc544\ub2c8\ub77c \uc5b8\uc778\uc2a4\ud1a8\ub7ec\uc600\uc74c \uc5b8\uc778\uc2a4\ud1a8\ub7ec\uac00 \uc885\ub8cc\ud558\uace0 \ub098\uba74 \uc790\uae30 \uc790\uc2e0\uc778 \ubc14\uc774\ub108\ub9ac\ub97c \uc9c0\uc6b0\ub824\uace0 \uae30\ub2e4\ub9ac\ub294 \uac83(Self Deleting) \uc774 \ucf54\ub4dc\ub294 CodeProject\uc5d0 10\ub144\uc804\uc5d0 \uc18c\uac1c\ub41c \ubc29\ubc95... \ucd9c\ucc98 : GeekNews - \uac1c\ubc1c\/\uae30\uc220\/\uc2a4\ud0c0\ud2b8\uc5c5 \ub274\uc2a4 \uc11c\ube44\uc2a4","rel":"","context":"&quot;IT&quot;\uc5d0\uc11c","block_context":{"text":"IT","link":"https:\/\/nori.company\/?cat=138"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":24899,"url":"https:\/\/nori.company\/?p=24899","url_meta":{"origin":22411,"position":4},"title":"React\uc640 Solid\uc758 \ucc28\uc774\uc810 \ud1ba\uc544\ubcf4\uae30","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 7\uc6d4 13\uc77c","format":false,"excerpt":"JSX \uc758 \uc6d0\uc870\uc778 React \uc640 JSX\uc5d0\uc11c \ud30c\uc0dd\ud558\uc5ec React\uc640 \ub2ec\ub9ac \uac00\uc0c1DOM\uc744 \uc0ac\uc6a9\ud558\uc9c0 \uc54a\ub294 Solid.js \uc758 \ucc28\uc774\uc810\uc744 \uc54c\uc544\ubcf4\uc558\uc2b5\ub2c8\ub2e4. React \uac1c\ubc1c\uc790\uac00 Solid.js \uc5d0 \uc811\uadfc\ud560 \uacbd\uc6b0\ub97c \uac00\uc815\ud558\uc5ec \ucc28\uc774\uc810\uc744 \ubcf4\uc558\uc744 \ub54c, \uae30\ucd08\uc801\uc73c\ub85c \uc544\ub798\uc640 \uac19\uc740 \ucc28\uc774\uc810\uc774 \uc788\uc2b5\ub2c8\ub2e4. React\uc758 \ud6c5 \ud568\uc218\ub294 \ucef4\ud3ec\ub10c\ud2b8 \ud568\uc218 \ub0b4\uc5d0\uc11c\ub9cc \uc0ac\uc6a9 \ud558 \ucd9c\ucc98 : GeekNews - \uac1c\ubc1c\/\uae30\uc220\/\uc2a4\ud0c0\ud2b8\uc5c5 \ub274\uc2a4 \uc11c\ube44\uc2a4","rel":"","context":"&quot;IT&quot;\uc5d0\uc11c","block_context":{"text":"IT","link":"https:\/\/nori.company\/?cat=138"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":23788,"url":"https:\/\/nori.company\/?p=23788","url_meta":{"origin":22411,"position":5},"title":"SQL:2023 \ub9b4\ub9ac\uc988","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 6\uc6d4 5\uc77c","format":false,"excerpt":"2023-06-01\uc77c\uc790, ISO\/IEC 9075-2:2023 \uc73c\ub85c \ucd5c\uc885 \uc2b9\uc778\ud558\uc5ec \ubc1c\ud589 \uc8fc\uc694 \ubcc0\uacbd\uc810\uc740 SQL\/PGQ: Graph \ucffc\ub9ac \uc5b8\uc5b4 \ucd94\uac00 JSON \ub370\uc774\ud130 \ud0c0\uc785 \ubc0f \ub2e4\uc591\ud55c \uc0c8 \uae30\ub2a5\ub4e4 \ucd94\uac00 \uae30\uc874 SQL \uc5b8\uc5b4\uc758 \ud5a5\uc0c1 \ubc0f \ubcc0\uacbd ... \ucd9c\ucc98 : GeekNews - \uac1c\ubc1c\/\uae30\uc220\/\uc2a4\ud0c0\ud2b8\uc5c5 \ub274\uc2a4 \uc11c\ube44\uc2a4","rel":"","context":"&quot;IT&quot;\uc5d0\uc11c","block_context":{"text":"IT","link":"https:\/\/nori.company\/?cat=138"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/nori.company\/index.php?rest_route=\/wp\/v2\/posts\/22411","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nori.company\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nori.company\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nori.company\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/nori.company\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=22411"}],"version-history":[{"count":1,"href":"https:\/\/nori.company\/index.php?rest_route=\/wp\/v2\/posts\/22411\/revisions"}],"predecessor-version":[{"id":22412,"href":"https:\/\/nori.company\/index.php?rest_route=\/wp\/v2\/posts\/22411\/revisions\/22412"}],"wp:attachment":[{"href":"https:\/\/nori.company\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=22411"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nori.company\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=22411"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nori.company\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=22411"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}