<\/span><\/h3>\n\n\n\n\u5982\u4e0b\u4f8b\u5b50\u662f\u9ed8\u8ba4\u7684\u5347\u5e8f\uff0c\u7b2c\u4e00\u884c\u8868\u793a\uff1a\u5c0f\u4e8e\u7b49\u4e8e\u6570\u503c1\u7684\u884c\u6570\u6bd4\u4f8b\u4e3a20%<\/p>\n\n\n\n
gbase> select id,cume_dist()over(order by id) cr from t2;\n+------+-----+\n| id | cr |\n+------+-----+\n| 1 | 0.2 |\n| 2 | 0.4 |\n| 3 | 0.6 |\n| 4 | 0.8 |\n| 5 | 1 |\n+------+-----+\n5 rows in set (Elapsed: 00:00:00.01)\n<\/code><\/pre>\n\n\n\n<\/span>\u5927\u4e8e\u7b49\u4e8e<\/span><\/h3>\n\n\n\n\u6392\u5e8f\u4e3adesc\uff0c\u7b2c\u4e00\u884c\u8868\u793a\uff1a\u5927\u4e8e\u7b49\u4e8e\u6570\u503c5\u7684\u884c\u6570\u6bd4\u4f8b\u4e3a20%\u3002<\/p>\n\n\n\n
gbase> select id,cume_dist()over(order by id desc) cr from t2;\n+------+-----+\n| id | cr |\n+------+-----+\n| 5 | 0.2 |\n| 4 | 0.4 |\n| 3 | 0.6 |\n| 2 | 0.8 |\n| 1 | 1 |\n+------+-----+\n5 rows in set (Elapsed: 00:00:00.02)\n<\/code><\/pre>\n\n\n\n<\/span>\u5e26\u5f00\u7a97partition<\/span><\/h3>\n\n\n\n\u6bcf\u4e2apartition\u5185\u4e0d\u5206\u522b\u8ba1\u7b97\u767e\u5206\u6bd4\u3002<\/p>\n\n\n\n
gbase> select * from t4;\n+------+------+\n| id | type |\n+------+------+\n| 1 | A |\n| 2 | A |\n| 3 | A |\n| 1 | B |\n| 2 | B |\n| 3 | B |\n| 4 | B |\n+------+------+\n7 rows in set (Elapsed: 00:00:00.00)\n\ngbase> select type,id,cume_dist()over(partition by type order by id) cr from t4;\n+------+------+-------------------+\n| type | id | cr |\n+------+------+-------------------+\n| A | 1 | 0.333333333333333 |\n| A | 2 | 0.666666666666667 |\n| A | 3 | 1 |\n| B | 1 | 0.25 |\n| B | 2 | 0.5 |\n| B | 3 | 0.75 |\n| B | 4 | 1 |\n+------+------+-------------------+\n7 rows in set (Elapsed: 00:00:00.07)\n<\/code><\/pre>\n\n\n\n<\/span>\u4e0ePercent_rank\u7684\u5bf9\u6bd4<\/span><\/h2>\n\n\n\npercent_rank\u662f\u8ba1\u7b97\u76f8\u5bf9\u4f4d\u7f6e\uff0c\u5305\u542b\u8d77\u70b90\uff0c\u800ccume_dist\u662f\u5305\u542b\u7b49\u4e8e\u7684\uff0c\u6240\u4ee5\u4e0d\u4f1a\u51fa\u73b00\u3002\u5982\u679c\u6570\u636e\u53ea\u67091\u884c\uff0c\u90a3\u4e48percent_rank\u4e3a<\/p>\n\n\n\n
\u8d77\u70b90\uff0c \u800ccume_dist\u4e3a1\uff08100%\uff09\u3002<\/p>\n\n\n\n
gbase> select id,cume_dist()over(order by id) cr,percent_rank()over(order by id) pr from t2;\n+------+-----+------+\n| id | cr | pr |\n+------+-----+------+\n| 1 | 0.2 | 0 |\n| 2 | 0.4 | 0.25 |\n| 3 | 0.6 | 0.5 |\n| 4 | 0.8 | 0.75 |\n| 5 | 1 | 1 |\n+------+-----+------+\n5 rows in set (Elapsed: 00:00:00.01)\n<\/code><\/pre>\n\n\n\n\u4e00\u884c\u6570\u636e<\/p>\n\n\n\n
gbase> select id,cume_dist()over(order by id) cr,percent_rank()over(order by id) pr from t5;\n+------+----+----+\n| id | cr | pr |\n+------+----+----+\n| 1 | 1 | 0 |\n+------+----+----+\n1 row in set (Elapsed: 00:00:00.02)\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"\u5357\u5927\u901a\u7528GBase 8a\u652f\u6301cume_dist \u51fd\u6570\uff0c\u7528\u4e8e\u8ba1\u7b97\u5c0f\u4e8e\u7b49\u4e8e\u6216\u8005\u5927\u4e8e\u7b49\u4e8e(\u6839\u636eorder\u7684\u987a\u5e8f)\u8be5\u503c\u7684\u767e\u5206\u6bd4\u3002<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[36,77],"class_list":["post-8985","post","type-post","status-publish","format-standard","hentry","category-gbase8a","tag-36","tag-olap"],"_links":{"self":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/8985","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/comments?post=8985"}],"version-history":[{"count":4,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/8985\/revisions"}],"predecessor-version":[{"id":9626,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/8985\/revisions\/9626"}],"wp:attachment":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/media?parent=8985"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/categories?post=8985"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/tags?post=8985"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}