\uc5f0\ubd09\uc744 \uacc4\uc0b0\ud558\ub294\ub370 \uc788\uc5b4\uc11c..
\n\uc5b4\ub5a4 \uc0ac\ub78c\uc740 \uc2dc\uae09\uc73c\ub85c \ubc1b\uace0, \uc5b4\ub5a4 \uc0ac\ub78c\uc740 \uc5f0\ubd09\uc73c\ub85c \ubc1b\uace0, \uc5b4\ub5a4 \uc0ac\ub78c\uc740 \ud310\ub9e4\ub7c9\uc5d0 \ub530\ub978 \ucee4\ubbf8\uc158\uc744 \ubc1b\ub294\ub2e4\uace0 \ud588\uc744\ub54c..
\n\uac01 \uc0ac\ub78c\ub4e4\uc758 \uc5f0\ubd09\uc744 \uad6c\ud558\ub294 \uacbd\uc6b0..
\nCASE \ubb38\uc744 \uc4f0\uba74 \ud504\ub85c\uadf8\ub7a8\uc5d0\uc11c \ub530\ub85c \ucf54\ub529\ud558\uc9c0 \uc54a\uc544\ub3c4 \ub41c\ub2e4.
\n\ub610\ud55c \ud544\uc694\uc5c6\ub294 \ub370\uc774\ud130\ub4e4\uc774 null\uac12\uc73c\ub85c \ub4e4\uc5b4\uac00 \uc788\ub2e4\uba74 COALESCE\ubb38\uc744 \uc0ac\uc6a9\ud558\uba74
\n\ub354 \uac04\ub2e8\ud574\uc9c0\uace0 \uc131\ub2a5\ub3c4 \uc88b\uc544\uc9c4\ub2e4.
\nCOALESCE\ud568\uc218\ub294 \uc5ec\ub7ec\uac1c\uc758 \ud45c\ud604\uc2dd \uc911\uc5d0\uc11c \uccab\ubc88\uc9f8\ub85c \ub098\ud0c0\ub098\ub294 \ub110\uc774 \uc544\ub2cc \uac12\uc744 \ub9ac\ud134\ud574\uc900\ub2e4.
\nCONVERT \uc640 CAST\ub294 \uc790\ub8cc\ud615\uc744 \ubc14\uafc0\ub54c \uc4f0\ub294 \ud568\uc218\ub85c CAST\ub294 ANSI \ud638\ud658\uc744 \uc704\ud574 \uc0ac\uc6a9\ub41c\ub2e4.<\/p>\n
\ub2e4\uc74c \uc608\uc81c\ub85c \uadf8 \uc4f0\uc784\uc0c8\ub97c \uc0b4\ud3b4\ubcf4\uc790<\/p>\n
select emp_id, [\uc5f0\ubd09] =
\n case
\n when hourly_wage IS NOT NULL
\n then convert(money,(hourly_wage * 40 * 52))
\n when sallary is not null
\n then convert(money, sallary)
\n else
\n convert(money,(commission * num_sales))
\n end
\nfrom wages<\/p>\n
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++<\/p>\n
select emp_id
\n, [\uc5f0\ubd09] = cast (
\n coalesce(hourly_wage*40*52,sallary,commission*num_sales) as money)
\nfrom wages<\/p>\n","protected":false},"excerpt":{"rendered":"
\uc5f0\ubd09\uc744 \uacc4\uc0b0\ud558\ub294\ub370 \uc788\uc5b4\uc11c.. \uc5b4\ub5a4 \uc0ac\ub78c\uc740 \uc2dc\uae09\uc73c\ub85c \ubc1b\uace0, \uc5b4\ub5a4 \uc0ac\ub78c\uc740 \uc5f0\ubd09\uc73c\ub85c \ubc1b\uace0, \uc5b4\ub5a4 \uc0ac\ub78c\uc740 \ud310\ub9e4\ub7c9\uc5d0 \ub530\ub978 \ucee4\ubbf8\uc158\uc744 \ubc1b\ub294\ub2e4\uace0 \ud588\uc744\ub54c.. \uac01 \uc0ac\ub78c\ub4e4\uc758 \uc5f0\ubd09\uc744 \uad6c\ud558\ub294 \uacbd\uc6b0.. CASE \ubb38\uc744 \uc4f0\uba74 \ud504\ub85c\uadf8\ub7a8\uc5d0\uc11c \ub530\ub85c \ucf54\ub529\ud558\uc9c0 \uc54a\uc544\ub3c4 \ub41c\ub2e4. \ub610\ud55c \ud544\uc694\uc5c6\ub294 \ub370\uc774\ud130\ub4e4\uc774 null\uac12\uc73c\ub85c \ub4e4\uc5b4\uac00 \uc788\ub2e4\uba74 COALESCE\ubb38\uc744 \uc0ac\uc6a9\ud558\uba74 \ub354 \uac04\ub2e8\ud574\uc9c0\uace0 \uc131\ub2a5\ub3c4 \uc88b\uc544\uc9c4\ub2e4. COALESCE\ud568\uc218\ub294 \uc5ec\ub7ec\uac1c\uc758 \ud45c\ud604\uc2dd \uc911\uc5d0\uc11c \uccab\ubc88\uc9f8\ub85c \ub098\ud0c0\ub098\ub294 \ub110\uc774 \uc544\ub2cc \uac12\uc744 \ub9ac\ud134\ud574\uc900\ub2e4. CONVERT \uc640 … \uacc4\uc18d \uc77d\uae30 “CASE \uc640 COALESCE \uc0ac\uc6a9\ud558\uae30”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1410","post","type-post","status-publish","format-standard","hentry","category-tip"],"_links":{"self":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1410","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1410"}],"version-history":[{"count":0,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1410\/revisions"}],"wp:attachment":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1410"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1410"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1410"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}