{"id":673,"date":"2006-08-11T02:00:00","date_gmt":"2006-08-10T17:00:00","guid":{"rendered":"https:\/\/ecoop.net\/memo\/2006-08-11-2.html"},"modified":"2006-08-11T02:00:00","modified_gmt":"2006-08-10T17:00:00","slug":"2006-08-11-2","status":"publish","type":"post","link":"https:\/\/www.ecoop.net\/memo\/archives\/2006-08-11-2.html","title":{"rendered":"RDBMS \u3067\u4efb\u610f\u306e\u30ec\u30b3\u30fc\u30c9\u304c\u3001\u6307\u5b9a\u3057\u305f\u6761\u4ef6\u3001\u9806\u5e8f\u306e\u6642\u306b\u4f55\u756a\u76ee\u306b\u306a\u308b\u304b\u3092\u8abf\u3079\u308b SQL \u6587\u306b\u3064\u3044\u3066"},"content":{"rendered":"

\n<\/p>\n

SELECT * FROM a_table WHERE condition ORDER BY a, b DESC, c\n<\/p><\/blockquote>\n

\u306e\u5834\u5408\u306f\u3001ID \u306e a,b,c \u306e\u5024\u3092\u305d\u308c\u305e\u308c an, bn, cn \u3068\u3057\u305f\u6642\u3001
\n\u524d\u304b\u3089\u306e\u4f4d\u7f6e n
\n{n| 0 <= n < (SELECT COUNT(*) FROM a_table)}\u306f\n<\/p>\n

SELECT COUNT(*) AS n FROM a_table WHERE
\n condition AND
\n (
\n   (a < an) OR
\n   (a = an AND b > bn) OR
\n   (a = an AND b = bn AND c < AS cn )
\n ) — … (A)\n<\/p><\/blockquote>\n

\u306e\u7d50\u679c\u3068\u306a\u308b\u3002
\n 
\n\u4f8b:\n<\/p>\n

NO: 0 1 2 3 4 5 6 7 8 9 10 11
\nID: 0 1 3 5 7 9 10 11 15 20 21 23
\n a: 1 1 1 1 2 2 2 2 3 3 3 3
\n b: 4 4 2 0 3 2 1 1 4 3 3 3
\n c: 0 1 0 2 3 3 2 3 2 3 3 4\n<\/p><\/blockquote>\n

\u30c6\u30fc\u30d6\u30eb\u306e\u5185\u5bb9\u304c\u4e0a\u8a18\u306e NO \u3092\u9664\u3044\u305f ID, a, b, c \u3092\u5c5e\u6027\u3068\u3057\u3066\u6301\u3061
\n\u691c\u4f53\u306e ID \u304c 10 \u306e\u6642
\na < an \u3092\u6e80\u305f\u3059\u8981\u7d20\u306f an == 2 \u306a\u306e\u3067 4 \u500b ..(1)
\na = an AND b > n \u3092\u6e80\u305f\u3059\u8981\u7d20\u306f bn == 1 \u306a\u306e\u3067 2 \u500b ..(2)
\na = an AND b = bn AND c < AS cn \u3092\u6e80\u305f\u3059\u8981\u7d20\u306f cn == 2 \u306a\u306e\u3067 0 \u500b ..(3)
\n\u5168\u3066\u306e\u8a08\u7b97\u306f\u6392\u4ed6\u306a\u306e\u3067 (A) \u306e\u7d50\u679c\u306f (1)+(2)+(3) = 6
\n\u3053\u308c\u306f 0 \u756a\u76ee\u304b\u3089\u6570\u3048\u305f\u6642\u306e \u4f4d\u7f6e NO \u306b\u4e00\u81f4\u3059\u308b\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

SELECT * FROM a_table WHERE condition ORDER BY a, b DESC, c \u306e\u5834\u5408\u306f\u3001ID \u306e a,b,c \u306e\u5024\u3092\u305d\u308c\u305e\u308c an, bn, cn \u3068\u3057\u305f\u6642\u3001 \u524d\u304b\u3089\u306e\u4f4d\u7f6e n … \u7d9a\u304d\u3092\u8aad\u3080 RDBMS \u3067\u4efb\u610f\u306e\u30ec\u30b3\u30fc\u30c9\u304c\u3001\u6307\u5b9a\u3057\u305f\u6761\u4ef6\u3001\u9806\u5e8f\u306e\u6642\u306b\u4f55\u756a\u76ee\u306b\u306a\u308b\u304b\u3092\u8abf\u3079\u308b SQL \u6587\u306b\u3064\u3044\u3066<\/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":[],"tags":[11],"class_list":["post-673","post","type-post","status-publish","format-standard","hentry","tag-misc"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.ecoop.net\/memo\/wp-json\/wp\/v2\/posts\/673","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ecoop.net\/memo\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ecoop.net\/memo\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ecoop.net\/memo\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ecoop.net\/memo\/wp-json\/wp\/v2\/comments?post=673"}],"version-history":[{"count":0,"href":"https:\/\/www.ecoop.net\/memo\/wp-json\/wp\/v2\/posts\/673\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.ecoop.net\/memo\/wp-json\/wp\/v2\/media?parent=673"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ecoop.net\/memo\/wp-json\/wp\/v2\/categories?post=673"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ecoop.net\/memo\/wp-json\/wp\/v2\/tags?post=673"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}