<\/span><\/h3>\n\n\n\ngbase> select version();\r\n+-------------------------------+\r\n| version() |\r\n+-------------------------------+\r\n| 9.5.3.28.18.r1_patch.650ab97f |\r\n+-------------------------------+\r\n1 row in set (Elapsed: 00:00:00.00)\n\ngbase> select name,id from t1 order by name,id;\r\n+-------+------+\r\n| name | id |\r\n+-------+------+\r\n| Name0 | 3 |\r\n| Name0 | 6 |\r\n| Name0 | 9 |\r\n| Name1 | 1 |\r\n| Name1 | 4 |\r\n| Name1 | 7 |\r\n| Name1 | 10 |\r\n| Name2 | 2 |\r\n| Name2 | 5 |\r\n| Name2 | 8 |\r\n+-------+------+\r\n10 rows in set (Elapsed: 00:00:00.03)<\/code><\/pre>\n\n\n\n<\/span>percentile_cont<\/span><\/h2>\n\n\n\n<\/span>\u8bed\u6cd5<\/span><\/h3>\n\n\n\nPERCENTILE_CONT ( numeric_literal )\r\n WITHIN GROUP ( ORDER BY order_by_expression [ ASC | DESC ] )\r\n OVER ( [ <partition_by_clause> ] )<\/code><\/pre>\n\n\n\n<\/span>\u53c2\u6570<\/span><\/h3>\n\n\n\n<\/span>numeric_literal<\/em><\/span><\/h4>\n\n\n\n\u8981\u8ba1\u7b97\u7684\u767e\u5206\u4f4d\u6570\u3002 \u8be5\u503c\u5fc5\u987b\u4ecb\u4e8e\u548c 1.0<\/code>. \u4e4b\u95f40.0<\/code>\u3002<\/p>\n\n\n\n<\/span>WITHIN GROUP(Order by)<\/span><\/h4>\n\n\n\n\u6307\u5b9a\u8981\u6392\u5e8f\u7684\u6570\u503c\u5217\u8868\uff0c\u5e76\u8ba1\u7b97\u767e\u5206\u4f4d\u6570\u3002 \u4ec5\u5141\u8bb8\u4e00\u4e2a order_by_expression \u3002 \u9ed8\u8ba4\u7684\u6392\u5e8f\u987a\u5e8f\u4e3a\u5347\u5e8f\u3002<\/p>\n\n\n\n
<\/span>OVER \uff08 <partition_by_clause> \uff09<\/span><\/h4>\n\n\n\n\u5c06\u5b50\u53e5\u751f\u6210\u7684\u00a0FROM<\/code>\u00a0\u7ed3\u679c\u96c6\u5212\u5206\u4e3a\u5e94\u7528\u767e\u5206\u4f4d\u51fd\u6570\u7684\u5206\u533a\u3002 <\/p>\n\n\n\n<\/span>\u6267\u884c\u6837\u4f8b<\/span><\/h3>\n\n\n\ngbase> select name,id,percentile_cont(0.5)within group(order by id ) over(partition by name)contId from t1 order by name,id;\r\n+-------+------+--------+\r\n| name | id | contId |\r\n+-------+------+--------+\r\n| Name0 | 3 | 6 |\r\n| Name0 | 6 | 6 |\r\n| Name0 | 9 | 6 |\r\n| Name1 | 1 | 5.5 |\r\n| Name1 | 4 | 5.5 |\r\n| Name1 | 7 | 5.5 |\r\n| Name1 | 10 | 5.5 |\r\n| Name2 | 2 | 5 |\r\n| Name2 | 5 | 5 |\r\n| Name2 | 8 | 5 |\r\n+-------+------+--------+\r\n10 rows in set (Elapsed: 00:00:00.08)<\/code><\/pre>\n\n\n\n<\/span>\u5907\u6ce8<\/span><\/h3>\n\n\n\n\u5f53\u4f4d\u7f6e\u547d\u4e2d\u65f6\uff0c\u6bd4\u5982Name0\uff0c\u4e00\u51713\u4e2a\u503c(\u5bf9\u5e940\uff0c0.5\uff0c1)\uff0c0.5\u6b63\u597d\u5bf9\u5e94\u7b2c\u4e8c\u4e2a\uff0c\u8fd4\u56de6<\/p>\n\n\n\n
\u5f53\u4f4d\u7f6e\u672a\u547d\u4e2d\u65f6\uff0c\u6bd4\u5982Name1\uff0c\u4e00\u51714\u4e2a\u503c\uff080\uff0c1\/3,2\/3,1)\uff0c0.5\u57281\/3\u548c2\/3\u4e4b\u95f4\uff0c\u505a\u7ebf\u6027\u5185\u63d2\u8ba1\u7b97(V=\u503c,P=\u4f4d\u7f6e)<\/p>\n\n\n\n
V1+(V2-V1)\/((P-P1)\/(P2-P1))<\/p>\n\n\n\n
4+\uff087-4)\/((0.5-1\/3)\/(2\/3-1\/3)) = 5.5<\/p>\n\n\n\n
- 2\/3\u76f8\u6bd41\/3\u7684\u767e\u5206\u4f4d\u5dee\u8ddd\u4e3a2\/3-1\/3=1\/3<\/li>
- 0.5\u76f8\u6bd41\/3\u7684\u767e\u5206\u4f4d\u5dee\u8ddd\u4e3a0.5-1\/3=1\/6<\/li>
- 0,5\u7684\u4f4d\u7f6e\u5360\u5dee\u8ddd\u4f4d\u7f6e\u7684\u767e\u5206\u6bd4 1\/6 \/ 1\/3 = 1\/2, \u4e5f\u5c31\u662f1\/3\u548c2\/3\u7684\u4e2d\u95f4<\/li>
- 1\/3\u548c2\/3\u5bf9\u5e94\u7684\u503c\u5dee\u8ddd\u4e3a 7-4=3<\/li>
- 0.5\u4f4d\u7f6e\u5bf9\u5e94\u7684\u63d2\u503c\u4e3a 3*1\/2=1.5<\/li>
- \u52a0\u4e0a\u57fa\u65701\/3\u7684\u503c4\uff0c 4+1.5=5.5<\/li><\/ul>\n\n\n\n
<\/span>percentile_disc<\/span><\/h2>\n\n\n\n<\/span>\u8bed\u6cd5<\/span><\/h3>\n\n\n\nPERCENTILE_DISC ( numeric_literal ) WITHIN GROUP ( ORDER BY order_by_expression [ ASC | DESC ] ) \r\n OVER ( [ <partition_by_clause> ] ) <\/code><\/pre>\n\n\n\n<\/span>\u53c2\u6570<\/span><\/h3>\n\n\n\n<\/span>numeric_literal<\/span><\/h4>\n\n\n\n\u8981\u8ba1\u7b97\u7684\u767e\u5206\u4f4d\u6570\u3002 \u8be5\u503c\u5fc5\u987b\u4ecb\u4e8e 0.0 \u548c 1.0 \u4e4b\u95f4\u3002<\/p>\n\n\n\n
<\/span>WITHIN GROUP(Order by)<\/span><\/h4>\n\n\n\n\u6307\u5b9a\u8981\u6392\u5e8f\u7684\u6570\u503c\u5217\u8868\uff0c\u5e76\u8ba1\u7b97\u767e\u5206\u4f4d\u6570\u3002 \u4ec5\u5141\u8bb8\u4e00\u4e2a order_by_expression \u3002 \u9ed8\u8ba4\u7684\u6392\u5e8f\u987a\u5e8f\u4e3a\u5347\u5e8f\u3002<\/p>\n\n\n\n
<\/span>OVER \uff08 <partition_by_clause> \uff09<\/span><\/h4>\n\n\n\n\u5c06\u5b50\u53e5\u751f\u6210\u7684 FROM<\/code> \u7ed3\u679c\u96c6\u5212\u5206\u4e3a\u5e94\u7528\u767e\u5206\u4f4d\u51fd\u6570\u7684\u5206\u533a\u3002 <\/p>\n\n\n\n<\/span>\u6267\u884c\u6837\u4f8b<\/span><\/h3>\n\n\n\n\rgbase> select name,id,percentile_disc(0.5)within group(order by id ) over(partition by name)discId from t1 order by name,id;\r\n+-------+------+--------+\r\n| name | id | discId |\r\n+-------+------+--------+\r\n| Name0 | 3 | 6 |\r\n| Name0 | 6 | 6 |\r\n| Name0 | 9 | 6 |\r\n| Name1 | 1 | 4 |\r\n| Name1 | 4 | 4 |\r\n| Name1 | 7 | 4 |\r\n| Name1 | 10 | 4 |\r\n| Name2 | 2 | 5 |\r\n| Name2 | 5 | 5 |\r\n| Name2 | 8 | 5 |\r\n+-------+------+--------+\r\n10 rows in set (Elapsed: 00:00:00.08)\n<\/code><\/pre>\n\n\n\n<\/span>\u5907\u6ce8<\/span><\/h3>\n\n\n\n\u5f53\u4f4d\u7f6e\u547d\u4e2d\u65f6\uff0c\u6bd4\u5982Name0\uff0c\u4e00\u51713\u4e2a\u503c(\u5bf9\u5e940\uff0c0.5\uff0c1)\uff0c0.5\u6b63\u597d\u5bf9\u5e94\u7b2c\u4e8c\u4e2a\uff0c\u8fd4\u56de6<\/p>\n\n\n\n
\u5f53\u4f4d\u7f6e\u672a\u547d\u4e2d\u65f6\uff0c\u6bd4\u5982Name1\uff0c\u4e00\u51714\u4e2a\u503c\uff080\uff0c1\/3,2\/3,1)\uff0c0.5\u4e0e\u524d\u540e\u4f4d\u7f6e\u7684\u8ddd\u79bb1\/3\u548c2\/3\u90fd\u662f1\/6\u76f8\u540c\uff0c\u9009\u62e9\u524d\u9762\u7684\u3002\u8fd4\u56de4<\/p>\n\n\n\n
1\/2-1\/3=1\/6\n2\/3-1\/2=1\/6<\/code><\/pre>\n\n\n\n\u4f4d\u7f6e\u7a0d\u5fae\u9760\u540e\u4e00\u70b9\uff0c\u6bd4\u59820.500000001\uff0c\u5219\u4f1a\u56e0\u4e3a\u79bb2\/3\u66f4\u4ec5\uff0c\u8fd4\u56de\u5176\u4f4d\u7f6e\u503c7<\/p>\n\n\n\n
gbase> select name,id,percentile_disc(0.500000001)within group(order by id ) over(partition by name)discId from t1 order by name,id;\r\n+-------+------+--------+\r\n| name | id | discId |\r\n+-------+------+--------+\r\n| Name0 | 3 | 6 |\r\n| Name0 | 6 | 6 |\r\n| Name0 | 9 | 6 |\r\n| Name1 | 1 | 7 |\r\n| Name1 | 4 | 7 |\r\n| Name1 | 7 | 7 |\r\n| Name1 | 10 | 7 |\r\n| Name2 | 2 | 5 |\r\n| Name2 | 5 | 5 |\r\n| Name2 | 8 | 5 |\r\n+-------+------+--------+\r\n10 rows in set (Elapsed: 00:00:00.09)\r\n<\/code><\/pre>\n\n\n\n<\/p>","protected":false},"excerpt":{"rendered":"
\u767e\u5206\u4f4d\u51fd\u6570\uff0c\u6307\u4e00\u7ec4\u6570\u636e\u4e2d\u7279\u5b9a\u767e\u5206\u6bd4\u4f4d\u7f6e\u7684\u503c\uff0c\u6700\u5178\u578b\u7684\u5c31\u662f\u4e2d\u4f4d\u6570(50%)\u3002\u5176\u4e2dpercentile_cont\u4e3a\u8fde\u7eed\u767e\u5206\u4f4d\uff0c\u5982\u679c\u6307\u5b9a\u4f4d\u7f6e\u6ca1\u6709\u503c\uff0c\u5219\u4f1a\u6839\u636e\u524d\u540e\u4f4d\u7f6e\u7684\u503c\u7ebf\u6027\u8ba1\u7b97\u503c\uff0c\u4e5f\u5c31\u662f\u8fd4\u56de\u503c\u4e0d\u4e00\u5b9a\u662f\u539f\u6765\u5b58\u5728\u7684\u503c\u3002percentile_disc\u5219\u4e3a\u4e0d\u8fde\u7eed\u767e\u5206\u4f4d\uff0c\u5982\u679c\u6307\u5b9a\u4f4d\u7f6e\u6ca1\u6709\u503c\uff0c\u5219\u4f1a\u6839\u636e\u767e\u5206\u4f4d\u8ba1\u7b97\u4e00\u4e2a\u6700\u8fd1\u7684\u4f4d\u7f6e\uff0c\u5e76\u8fd4\u56de\u8be5\u503c\u3002\u672c\u6587\u4ecb\u7ecdGBase 8a\u91cc\u8fd9\u4e9b\u51fd\u6570\u7684\u8bed\u6cd5\u548c\u4f7f\u7528\u6837\u4f8b\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],"class_list":["post-12961","post","type-post","status-publish","format-standard","hentry","category-gbase8a","tag-36"],"_links":{"self":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/12961","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=12961"}],"version-history":[{"count":1,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/12961\/revisions"}],"predecessor-version":[{"id":12962,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/12961\/revisions\/12962"}],"wp:attachment":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/media?parent=12961"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/categories?post=12961"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/tags?post=12961"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}