{"id":480,"date":"2014-05-21T08:23:29","date_gmt":"2014-05-20T23:23:29","guid":{"rendered":"http:\/\/backup.me.ne.kr\/?p=480"},"modified":"2014-05-21T08:23:29","modified_gmt":"2014-05-20T23:23:29","slug":"%ea%b0%84%eb%8b%a8%ed%95%9c-%ed%8a%b8%eb%a6%ad-sql%eb%a1%9c-%ed%8a%b9%ec%a0%95-%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%a7%8c-%ec%9a%b0%ec%84%a0-%ec%a0%95%eb%a0%ac%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"http:\/\/jhp.io\/?p=480","title":{"rendered":"[\uac04\ub2e8\ud55c \ud2b8\ub9ad] SQL\ub85c \ud2b9\uc815 \ub370\uc774\ud130\ub9cc \uc6b0\uc120 \uc815\ub82c\ud558\uae30"},"content":{"rendered":"

\uac04\ud639 DB\ub97c \uc0ac\uc6a9\ud558\ub294 \uc5b4\ub5a4 \ud504\ub85c\uadf8\ub7a8\uc5d0\uc11c \ub370\uc774\ud130\ubcc4\ub85c \uc815\ub82c\uc744 \ud574\uc57c\ud558\ub294\ub370 \ud2b9\uc815 \ub370\uc774\ud130\ub9cc \uace8\ub77c \ub2e4\ub978 \ub370\uc774\ud130\ubcf4\ub2e4 \uc6b0\uc120 \uc815\ub82c\uc744 \ud574\uc57c \ud560 \ub54c\uac00 \uc788\ub2e4. \uc608\ub97c \ub4e4\uc5b4 \uc219\ubc15\uc2dc\uc124 \uc608\uc57d \ud504\ub85c\uadf8\ub7a8\uc5d0\uc11c \uc811\uc218\ubc1b\uc544\uc11c \uad00\ub9ac \ud504\ub85c\uadf8\ub7a8\uc5d0\uc11c \ub0a0\uc9dc\ubcc4\ub85c \uc815\ub82c\ud574\uc11c \uc608\uc57d \ub370\uc774\ud130\ub97c \ubcf4\uc5ec\uc8fc\ub294\ub370, \uc131\uc218\uae30\ub54c \uc608\uc57d \uc811\uc218 \ub370\uc774\ud130\uac00 \ub108\ubb34 \ub9ce\uc544\uc11c \uc624\ub298 \uc608\uc57d \ub4e4\uc5b4\uc628 \uac83\uc744 \ucc98\ub9ac\ud558\ub824\uba74 \ud398\uc774\uc9c0\ub97c \ub4a4\ub85c \uac00\uc11c \ucc3e\uc544\uc57c \ud558\uac70\ub098 \uac80\uc0c9\uc744 \ud558\ub294 \uacbd\uc6b0\uac00 \uc0dd\uae34\ub2e4. \uadf8\uc678 \uc5ec\ub7ec\uac00\uc9c0\uac00 \uc788\uc9c0\ub9cc \uc6b0\uc120 \uc704\uc758 \uc0c1\ud669\uc744 \uac00\uc815\ud55c\ub2e4.<\/p>\n

\ub9cc\uc57d SQL Server, MySQL, Oracle\uc758 booking_data\ub780 \ud14c\uc774\ube14\uc5d0 \ub2e4\uc74c\uacfc \uac19\uc740 \ud14c\uc774\ube14\uc774 \uc874\uc7ac\ud55c\ub2e4\uace0 \uac00\uc815\ud558\uace0,
\n+————–+————-+
\n| Field | Type |
\n+————–+————-+
\n| seq | int(11) |
\n| bookers_name | varchar(32) |
\n| booked_room | int(5) |
\n| booked_date | varchar(12) |
\n+————–+————-+<\/p>\n

\uadf8 \ud14c\uc774\ube14\uc5d0 \ub2e4\uc74c\uacfc \uac19\uc740 \ub370\uc774\ud130\uac00 \uc788\ub2e4\uace0 \uac00\uc815\ud55c\ub2e4.<\/p>\n

+—–+——————–+————-+————-+
\n| seq | bookers_name | booked_room | booked_date |
\n+—–+——————–+————-+————-+
\n| 1 | Aldrich Stauffman | 101 | 2013-06-30 |
\n| 2 | Ryan Lucas | 201 | 2013-06-31 |
\n| 3 | Dominique Lefebvre | 201 | 2013-06-31 |
\n| 4 | Reimund Heinzel | 301 | 2013-06-02 |
\n| 5 | Richard Taylor | 301 | 2013-07-02 |
\n+—–+——————–+————-+————-+<\/p>\n

\uc608\ub97c \ub4e4\uc5b4 6\uc6d4 31\uc77c\uc5d0 \ub370\uc774\ud130\ub97c \uc6b0\uc120 \uc815\ub82c\ud558\uace0\uc790 \ud55c\ub2e4. \ub77c\uc774\uc5b8 \ub8e8\uce74\uc2a4\uc640 \ub3c4\ubbf8\ub2c8\ud06c \ub974\ud398\ube0c\ub974\uac00 \ub2e4\ub978 \uc138 \uc0ac\ub78c\uc758 \uc608\uc57d\uac74\ubcf4\ub2e4 \ucd5c\uc0c1\uc704\ub85c \uc62c\ub77c\uc640\uc57c \ud55c\ub2e4. \ub2e8\uc21c\ud788 \ub0a0\uc9dc\ub97c \ucd5c\uadfc \uc21c\uc73c\ub85c \uc815\ub82c\ud558\uac8c \ub41c\ub2e4\uba74 \ub9ac\ucc28\ub4dc \ud14c\uc77c\ub7ec\uac00 \uc81c\uc77c \ucc98\uc74c \uc62c\ub77c\uc624\uac8c \ub420 \uac83\uc774\uace0, \uc5ed\uc21c\uc73c\ub85c \uc815\ub82c\ud558\uba74 \ub3c5\uc77c\uc778 \ub450\uba85\uc774 \uc81c\uc77c \ucc98\uc74c \uc62c\ub77c\uc628\ub2e4.<\/p>\n

[MySQL]<\/p>\n

MySQL\uc758 \uacbd\uc6b0 \ub0b4\uc7a5 \ud568\uc218\uac00 \ub9ce\uc740\ub370, \uc5ec\uae30\uc11c\ub3c4 \uc774\uac78 \uc774\uc6a9\ud560 \uc218 \uc788\ub2e4. \ud558\ub294 \ubc29\ubc95\uc740 \ub2e8\uc21c\ud788 order by \uc808\uc5d0\uc11c field \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uba74 \ub41c\ub2e4.<\/p>\n

field(\ud544\ub4dc\uba85, \uc815\ub82c\ub370\uc774\ud1301[, \uc815\ub82c\ub370\uc774\ud1302 , …])<\/p>\n

\uae30\uc874\uc5d0 \ub2e4\uc74c\uacfc \uac19\uc740 \ucffc\ub9ac\uac00 \uc788\uc744 \ub54c<\/p>\n

SELECT * FROM booking_data ORDER BY booking_date DESC;<\/p>\n

\ub2e4\uc74c\ucc98\ub7fc \ucd94\uac00\ud55c\ub2e4.<\/p>\n

SELECT * FROM booking_data ORDER BY field(booking_date,’2013-06-31′) desc, booking_date DESC;
\n[Oracle \/ SQL Server \uacf5\ud1b5]<\/p>\n

\ubc18\uba74 \uc624\ub77c\ud074\uc740 \uc800\ub7f0 \uad6c\ubb38\uc744 \uc9c0\uc6d0\ud558\uc9c0 \uc54a\uc544 \uc57d\uac04 \uaf3c\uc218\ub97c \uc368\uc57c \ud558\ub294\ub370, \uc774\ub97c \uc774\uc6a9\ud558\uba74 \ucffc\ub9ac\uac00 \uae38\uc5b4\uc9c8 \uc218 \uc788\uc5b4 \uc8fc\uc758\ub97c \uc694\ud55c\ub2e4. \uc815\ub82c\uc744 \uc8fc\ub294 \ubc29\ubc95\uc740, CASE \uad6c\ubd84\uc744 \uc0ac\uc6a9\ud558\uc5ec \ud2b9\uc815 \ub370\uc774\ud130\ub97c Alias\ub85c \uc784\uc2dc \uc815\ub82c \uac12\uc744 \ubd80\uc5ec\ud55c \ub4a4 \uadf8\uac83\uc744 \uae30\uc900\uc73c\ub85c \uc815\ub82c\ud574\uc8fc\uba74 \ub41c\ub2e4. \ub2e4\uc74c\uacfc \uac19\uc774 \ub9cc\ub4e4\uc5b4 \ub0bc \uc218 \uc788\ub2e4. \ub300\ub7b5 \ud615\uc2dd\uc740<\/p>\n

SELECT \ub298_\ubf51\ub358_\ub300\ub85c, CASE WHEN \uc5f4 = \ub370\uc774\ud130 THEN \uc815\ub82c_\uc6b0\uc120\uc21c\uc704 [WHEN \uc5f42 = \ub370\uc774\ud1302 THEN \uc815\ub82c_\uc6b0\uc120\uc21c\uc7042 […]] ELSE ‘0’ END Alias\uba85 FROM \ub370\uc774\ud130\uac00_\uc788\ub294_\ud14c\uc774\ube14 ORDER BY Alias\uba85 [ASC|DESC] …
\n\uacfc \uac19\uc740 \ud615\uc2dd. \uc608\ub97c \ub4e4\uc5b4 \uae30\uc874\uc5d0 \ub2e4\uc74c\uacfc \uac19\uc740 \ucffc\ub9ac\uac00 \uc788\uc744 \ub54c<\/p>\n

SELECT * FROM booking_data ORDER BY booking_date DESC;<\/p>\n

\ub2e4\uc74c\ucc98\ub7fc \ucd94\uac00\ud574\uc900\ub2e4.<\/p>\n

SELECT *, CASE WHEN booking_date = ‘2013-06-31’ THEN ‘1’ ELSE ‘0’ END DATE_PRIORITY FROM booking_data ORDER BY DATE_PRIORITY DESC, booking_date DESC;<\/p>\n

\ub2e4\ub9cc \ucffc\ub9ac\uac00 \ub108\ubb34 \uae38\uc5b4\uc9c0\uae30 \ub54c\ubb38\uc5d0, \uac00\ub2a5\ud558\ub2e4\uba74 \ud504\ub85c\uc2dc\uc838 \ud615\ud0dc\ub85c \ub9cc\ub4dc\ub294 \uac83\ub3c4 \uc88b\ub2e4.<\/p>\n

\uc704 \ub450 \ubc29\ubc95\uc73c\ub85c \ucffc\ub9ac\ub97c \uc2e4\ud589\ud558\uba74 \ub2e4\uc74c\uacfc \uac19\uc740 \uacb0\uacfc\uac00 \ub098\uc628\ub2e4. (Oracle\uc774\ub098 MSSQL\ubc29\ubc95\uc744 \uc0ac\uc6a9\ud558\uba74 \ud68c\uc0c9\uc73c\ub85c \ucc98\ub9ac\ub41c \uc5f4\uc774 \uc0c8\ub85c \ucd9c\ub825\ub41c\ub2e4.)<\/p>\n

+—–+——————–+————-+————-+—————+
\n| seq | bookers_name | booked_room | booked_date | DATE_PRIORITY |
\n+—–+——————–+————-+————-+—————+
\n| 2 | Ryan Lucas | 201 | 2013-06-31 | 1 |
\n| 3 | Dominique Lefebvre | 201 | 2013-06-31 | 1 |
\n<\/span>| 5 | Richard Taylor | 301 | 2013-07-02 | 0 |
\n| 1 | Aldrich Stauffman | 101 | 2013-06-30 | 0 |
\n<\/span>| 4 | Reimund Heinzel | 301 | 2013-06-02 | 0 |
\n<\/span>+—–+——————–+————-+————-+—————+<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

\uac04\ud639 DB\ub97c \uc0ac\uc6a9\ud558\ub294 \uc5b4\ub5a4 \ud504\ub85c\uadf8\ub7a8\uc5d0\uc11c \ub370\uc774\ud130\ubcc4\ub85c \uc815\ub82c\uc744 \ud574\uc57c\ud558\ub294\ub370 \ud2b9\uc815 \ub370\uc774\ud130\ub9cc \uace8\ub77c \ub2e4\ub978 \ub370\uc774\ud130\ubcf4\ub2e4 \uc6b0\uc120 \uc815\ub82c\uc744 \ud574\uc57c \ud560 \ub54c\uac00 \uc788\ub2e4. \uc608\ub97c \ub4e4\uc5b4 \uc219\ubc15\uc2dc\uc124 \uc608\uc57d \ud504\ub85c\uadf8\ub7a8\uc5d0\uc11c \uc811\uc218\ubc1b\uc544\uc11c \uad00\ub9ac \ud504\ub85c\uadf8\ub7a8\uc5d0\uc11c \ub0a0\uc9dc\ubcc4\ub85c \uc815\ub82c\ud574\uc11c \uc608\uc57d \ub370\uc774\ud130\ub97c \ubcf4\uc5ec\uc8fc\ub294\ub370, \uc131\uc218\uae30\ub54c \uc608\uc57d \uc811\uc218 \ub370\uc774\ud130\uac00 \ub108\ubb34 \ub9ce\uc544\uc11c \uc624\ub298 \uc608\uc57d \ub4e4\uc5b4\uc628 \uac83\uc744 \ucc98\ub9ac\ud558\ub824\uba74 \ud398\uc774\uc9c0\ub97c \ub4a4\ub85c \uac00\uc11c \ucc3e\uc544\uc57c \ud558\uac70\ub098 \uac80\uc0c9\uc744 \ud558\ub294 \uacbd\uc6b0\uac00 \uc0dd\uae34\ub2e4. \uadf8\uc678 \uc5ec\ub7ec\uac00\uc9c0\uac00 \uc788\uc9c0\ub9cc […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19,16],"tags":[],"class_list":["post-480","post","type-post","status-publish","format-standard","hentry","category-php-mysql","category-programming"],"_links":{"self":[{"href":"http:\/\/jhp.io\/index.php?rest_route=\/wp\/v2\/posts\/480","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/jhp.io\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/jhp.io\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/jhp.io\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/jhp.io\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=480"}],"version-history":[{"count":0,"href":"http:\/\/jhp.io\/index.php?rest_route=\/wp\/v2\/posts\/480\/revisions"}],"wp:attachment":[{"href":"http:\/\/jhp.io\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=480"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/jhp.io\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=480"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/jhp.io\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=480"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}